Hi, You can either use the query mechanism to output whatever you like, or build your own dataview based on the datatable, or build a new datatable based on the previous datatable.....
Here is the Query language ref: http://code.google.com/apis/chart/interactive/docs/querylanguage.html And a general ref to the datatable/dataview: http://code.google.com/apis/chart/interactive/docs/reference.html On Sat, Dec 3, 2011 at 7:42 PM, Timothy W <[email protected]>wrote: > I'm using a Google Spreadsheet as a data source to make a chart > similar to the NameVoyager (http://babynamewizard.com/voyager) on a > smaller scale. > > My data is in the format: > > _____ Date1 Date2 Date3 Date4 ... > Item1 > Item2 > Item3 > Item4 > ... > > Making an Area Chart with this produces a graph with the Items along > the X-axis, and the Dates as the various lines. This isn't what I > want, so I switched the data around like so: > > _____ Item1 Item2 Item3 Item4 ... > Date1 > Date2 > Date3 > Date4 > ... > > This gives the graph I want, however as far as I know, now I can't do > queries on the Item Names since it's represented by a row. I can only > stop certain dates from appearing along the X-axis, which is pointless > for me. > > Is there anyway to get the chart to display how I want it to (dates > along the x-axis; lines in the chart represent different items) and > still be able to filter based on item name? > > -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To post to this group, send email to > [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/google-visualization-api?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
