If you actually have more data in your spreadsheet that you don't want to be part of this chart, then you will need the range parameter. Make sure you have formatted these data columns as numbers.
A good debugging technique is to show the data in a Table chart, just to see what you are getting. On Thu, May 19, 2016 at 10:38 AM, Greg Sommerville < [email protected]> wrote: > Yes, that's what I did. Column A is my main item, and columns B - E have > data that relate to that main item. I'd like to have columns B-E used as > the parts of the stacked bar - in other words, each row of my spreadsheet > resulting in a separate bar. Unfortunately, I get an error (something > like, "All data has to be of the same type"). > > I'm not sure whether I should be using the /range suffix, or add a query. > I really just want columns A through E, as I've described above. > > Thanks for the help. > > > On Thursday, May 19, 2016 at 10:28:02 AM UTC-4, Daniel LaLiberte wrote: > >> The BarChart is basically the same as the ColumnChart with a different >> orientation. The data is the same for both. The first column is for the >> domain, which on the BarChart is displayed along the vertical or y-axis. >> The other columns are for series (and roles applied to the series). Hope >> that helps. >> >> On Thu, May 19, 2016 at 10:15 AM, Greg Sommerville <[email protected] >> > wrote: >> >>> I'd like to set up a Google Sheets spreadsheet with data for a stacked >>> bar chart, but I can't figure out the best way to structure the sheet (or >>> query it). >>> >>> Does anyone have an example of how to use data from a Sheets document, >>> resulting in a stacked bar chart? All of the examples I've seen >>> show JavaScript literal data, which is usually an array of arrays. >>> >>> Thanks! >>> >>> -- >>> 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/ecdb7fe0-9caf-4cf6-a213-38e6127875af%40googlegroups.com >>> <https://groups.google.com/d/msgid/google-visualization-api/ecdb7fe0-9caf-4cf6-a213-38e6127875af%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/fbfeef00-e52b-404b-b4ca-117955b2d7f2%40googlegroups.com > <https://groups.google.com/d/msgid/google-visualization-api/fbfeef00-e52b-404b-b4ca-117955b2d7f2%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/CAOtcSJN1DKd7pUa95si035o3usb9nPY6rYDqsMRk5pAFZ3kdWw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
