Unfortunately, I believe there is no option in Sheets to specify that a column is for tooltips. If the whole column is formatted as a strings, then it will probably be used as annotations for the preceding column.
On Tue, Dec 15, 2015 at 5:30 PM, Nick Dunbar <[email protected]> wrote: > Daniel, > It's working now. I had an additional last column for tooltip in the > Google sheet with the heading > {type:'string',role:'tooltip'} which seemed to be triggering the error. > Do you know how to format a tooltip column in the Google sheet so it loads > correctly into the dataTable? > Thanks for your help > Nick > > On Tue, Dec 15, 2015 at 10:21 PM, Nick Dunbar <[email protected]> > wrote: > >> 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/CAO5F7cvVEA9n3gxwNQXeu6wHF4S9_yq%2Brr_QcDnmMqE5Z4z7qQ%40mail.gmail.com > <https://groups.google.com/d/msgid/google-visualization-api/CAO5F7cvVEA9n3gxwNQXeu6wHF4S9_yq%2Brr_QcDnmMqE5Z4z7qQ%40mail.gmail.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/CAOtcSJOT9N_rc3%2BdAqMve5oSc8zcODLhW7jt77XNhm9XJbqB5A%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
