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] > <javascript:>> 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] >> <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> 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] <javascript:> 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. For more options, visit https://groups.google.com/d/optout.
