I'm using a the Query object to return a three columns of a table from a google spreadsheet. The first column is a label column, the 2nd and 3rd data values.
I'm trying to create a dashboard binding a CategoryPicker control object and a ControlWrapper (ScatterChart) object. I'd like to use the Category Picker as a means of filtering the rows within the data (by selecting the row labels in the first or label column) and then have the remaining two columns of data drawn within the scatter chart. I am knew to this API and I am struggling with how to concurrently allow the CategoryPicker to work and exclude the label column from the ScatterPlot ControlWrapper object. I've tried using a DataView to limit the Queried data view to the 2nd and 3rd columns, but I believe the Dashboard object binding method needs all three columns to support the CategoryPicker's function. What's the appropriate way to go about achieving this outcome? Thanks in advance. -- 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.
