Hi Daniel, Apart from the first column they are all numbers. I replaced nulls with zeroes in the Excel sheet I pasted into the Google sheet, and they look kosher. I will try to put together a fiddle. Best, Nick
On Tue, Dec 15, 2015 at 8:05 PM, 'Daniel LaLiberte' via Google Visualization API <[email protected]> wrote: > Hi Nick, > > We can't tell what might be going wrong just by looking at your options. > Since it is complaining about your data columns, you should check that, in > fact, all your columns after the first really are numbers. If you > formatted some as strings, or if you have columns outside the range you > thought you were using, that could explain the error. > One easy way to check this is to use a Table chart instead of your > ComboChart. > > On Tue, Dec 15, 2015 at 2:18 PM, <[email protected]> wrote: > >> Hi, >> I am trying to create a combo chart with a continuous time x axis that >> has seriesType: 'bars' and series: {11: {type: 'area', color: 'red'}} for >> the last set of data. I am running this off a dataTable obtained from a >> Google sheet that has dates in the first column and numbers in the >> remaining columns. However, I keep getting ''All series on a given axis >> must be of the same data type' errors. What am I doing wrong? >> These are the chart options I am using via ChartWrapper: >> >> chartType: 'ComboChart', >> containerId: 'chart_div', >> dataTable: data, >> options: { >> title: 'combo chart', >> width: 800, >> height: 400, >> backgroundColor: 'transparent', >> interpolateNulls: true, >> seriesType: 'bars', >> series: {11: {type: 'area', color: 'red'}} >> } >> >> All help appreciated. >> Nick >> >> -- >> 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/b446fca1-3007-4ec7-b091-ead67a6d4614%40googlegroups.com >> <https://groups.google.com/d/msgid/google-visualization-api/b446fca1-3007-4ec7-b091-ead67a6d4614%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 a topic in the > Google Groups "Google Visualization API" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/google-visualization-api/5CFWLN7PlBg/unsubscribe > . > To unsubscribe from this group and all its topics, 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/CAOtcSJO1hYuaR_a7f5bc0sa7JpYHg0N_hXS0C%3D0zDs%3DrbQ%3D2qA%40mail.gmail.com > <https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJO1hYuaR_a7f5bc0sa7JpYHg0N_hXS0C%3D0zDs%3DrbQ%3D2qA%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- 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/CAO5F7cuUWaRwA-8GK4jOw%3Dy4E19zCM1yk-6gxdvW-0GHqkRb3w%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
