Your data has a first column that is numbers, then 2 string columns. How are you expecting to use this with ComboChart? Here is the documentation on the data format expected for ComboChart: https://google-developers.appspot.com/chart/interactive/docs/gallery/combochart#data-format
Basically, you can have a first column of strings, but the rest have to be numbers, unless you have role columns for tooltips or styles interspersed. On Thu, Feb 25, 2016 at 12:43 PM, Muhammad Liaquat < [email protected]> wrote: > I have tried this data loaded from database, given error (screenshot > attached) + same code attached > > var data=[ > > ['CategoryId','CategoryName','ProductName','BarAverage','LineAvergage', > { role: 'style' }, { role: 'tooltip' }], > > [1,'Air Fresheners','Febreze NOTICEables GAIN Dual Scented > Oils',3,8,'',''], > [1,'Air Fresheners','Febreze Fabric Refresher Free Nature',3,8,'',''], > [1,'Air Fresheners','Fresh Wave Super Gel',3,8,'',''], > [1,'Air Fresheners','Pure Citrus Orange Air Freshener',3,8,'',''], > [1,'Air Fresheners','Air Wick Freshmatic Ultra',3,8,'',''], > > [2,'Beverages','Coca Cola',3,8,'',''], > [2,'Beverages','Fanta',3,8,'',''], > [2,'Beverages','Nestea Lemon',3,8,'',''], > [2,'Beverages','Cappy Apple',3,8,'',''], > [2,'Beverages','Fanta',3,8,'',''], > [2,'Beverages','Hennessy',3,8,'',''], > > > [3,'Cakes','Nut and Frangipan Bar',3,8,'',''], > [3,'Cakes','Oats and Nutella Cookie',3,8,'',''], > [3,'Cakes','Granola Bar',3,8,'',''] > > > ] > > > On Wednesday, 24 February 2016 22:03:51 UTC+5, Daniel LaLiberte wrote: >> >> If you are loading different data each time, then you will have to >> compute the ticks array from your data by some means. You'll also have to >> determine the viewWindow.max from the number of rows. Whether you use odd >> values for where your names go is up to you. >> >> On Wed, Feb 24, 2016 at 12:00 PM, Muhammad Liaquat <[email protected] >> > wrote: >> >>> If i am load data dynamically then I will use V: odd series? >>> >>> On Wednesday, 24 February 2016 21:56:41 UTC+5, Daniel LaLiberte wrote: >>>> >>>> Since you want strings for your Name column, it would probably be >>>> easiest to actually keep using numbers, but also use the 'ticks' option >>>> like this: >>>> hAxis: { >>>> viewWindow: { min: 0, max: 6 }, >>>> ticks: [{v: 1, f: 'ABC'}, {v: 3, f: 'DEF'}, {v: 5, f: 'GHI'}] >>>> }, >>>> >>>> http://jsfiddle.net/vmb4odkt/16/ >>>> >>>> On Wed, Feb 24, 2016 at 11:45 AM, Muhammad Liaquat < >>>> [email protected]> wrote: >>>> >>>>> I have to make data as below >>>>> >>>>> var data = google.visualization.arrayToDataTable([ >>>>> >>>>> ['Name', 'Average Level', 'District Average'], >>>>> >>>>> ['ABC', 3, 3.89771634615385], >>>>> ['DEF', 5, 3.89771634615385], >>>>> ['GHI', 4.5, 3.89771634615385], >>>>> ['JKL', 3.1, 3.89771634615385] >>>>> >>>>> ]); >>>>> >>>>> http://jsfiddle.net/vmb4odkt/14/ >>>>> >>>>> On Wednesday, 24 February 2016 21:25:45 UTC+5, Daniel LaLiberte wrote: >>>>>> >>>>>> Your data does not correspond to what you are trying to draw. This >>>>>> is closer: http://jsfiddle.net/vmb4odkt/14/ >>>>>> >>>>>> You don't need the extra column for the extensions of the line, since >>>>>> you can add them to the series 1 line. >>>>>> >>>>>> On Wed, Feb 24, 2016 at 11:04 AM, Muhammad Liaquat < >>>>>> [email protected]> wrote: >>>>>> >>>>>>> I have tried to update many option and data but couldn't render >>>>>>> chart as expected (screenshot attached) >>>>>>> >>>>>>> http://jsfiddle.net/vmb4odkt/ >>>>>>> >>>>>>> -- >>>>>>> You received this message because you are subscribed to the Google >>>>>>> Groups "Google Visualization API" group. >>>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>>> send an email to >>>>>>> [email protected]. >>>>>>> To post to this group, send email to >>>>>>> [email protected]. >>>>>>> Visit this group at >>>>>>> https://groups.google.com/group/google-visualization-api. >>>>>>> To view this discussion on the web visit >>>>>>> https://groups.google.com/d/msgid/google-visualization-api/00007b68-7935-4ffa-8303-e6cd4865d234%40googlegroups.com >>>>>>> <https://groups.google.com/d/msgid/google-visualization-api/00007b68-7935-4ffa-8303-e6cd4865d234%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>> . >>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Daniel LaLiberte >>>>>> <https://plus.google.com/100631381223468223275?prsrc=2> >>>>>> [email protected] 5CC, Cambridge MA >>>>>> >>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "Google Visualization API" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an email to [email protected]. >>>>> To post to this group, send email to [email protected]. >>>>> Visit this group at >>>>> https://groups.google.com/group/google-visualization-api. >>>>> To view this discussion on the web visit >>>>> https://groups.google.com/d/msgid/google-visualization-api/13e72af3-02e7-4ceb-882e-b1f33d087a69%40googlegroups.com >>>>> <https://groups.google.com/d/msgid/google-visualization-api/13e72af3-02e7-4ceb-882e-b1f33d087a69%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>> . >>>>> >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> >>>> >>>> >>>> -- >>>> Daniel LaLiberte >>>> <https://plus.google.com/100631381223468223275?prsrc=2> >>>> [email protected] 5CC, Cambridge MA >>>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Google Visualization API" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To post to this group, send email to [email protected]. >>> Visit this group at >>> https://groups.google.com/group/google-visualization-api. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/google-visualization-api/784dff25-2594-48ec-a6fc-4e2e00773360%40googlegroups.com >>> <https://groups.google.com/d/msgid/google-visualization-api/784dff25-2594-48ec-a6fc-4e2e00773360%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> >> -- >> Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> >> [email protected] 5CC, Cambridge MA >> > -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to > [email protected]. > Visit this group at > https://groups.google.com/group/google-visualization-api. > To view this discussion on the web visit > https://groups.google.com/d/msgid/google-visualization-api/2019aa5e-0d97-40f8-90b5-cd779397b87b%40googlegroups.com > <https://groups.google.com/d/msgid/google-visualization-api/2019aa5e-0d97-40f8-90b5-cd779397b87b%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> [email protected] <[email protected]> 5CC, Cambridge MA -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJPJgbRFKMDhQk3ov527VXbj5ea1py4vSo-mos%3DJkR-BYg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
