You can create standard HTML checkboxes, selectboxes, or whatever you like and attach event handlers to them to choose which columns to draw. If you like the look of the built-in selectors, I wrote a hack that turns a category filter into a column filter: http://jsfiddle.net/asgallant/WaUu2/
You'll need all of the code there (including the HTML at the top). Replace the "data" DataTable with your DataTable and the "chart" ChartWrapper with your ChartWrapper. On Sunday, May 20, 2012 11:52:15 AM UTC-4, Geneocide wrote: > > yay. I got it to work... somehow. Unfortunately I now realize it's not > going to do exactly what I want. If I have a column chart with 3 sets > of data in each column, can I get the picker to let me pick of those > 3? > > Like, say I have year 2000 to 2010 and each year I have the sale > figures of Bill, Joe and Sally. I want the picker to let me pick if I > show all 3 people, or just 2 or 1, not whether I show all 10 years or > just some of them. > > Is there a relatively easy way to do this? > > On May 20, 12:16 am, ChartMan <[email protected]> wrote: > > The ChartWrapper supports Charts data source URLs - > https://developers.google.com/chart/interactive/docs/queries > > If you can't make your data available via a URL then you can fetch the > data > > to your client and create a google.visualization.DataTable. > > Once you have the data table you can create a > > google.visualization.ChartWrapper and assign it's "dataTable" field. > > Controls would now accept your ChartWrapper and should operate normally. > > > > HTH > > ChartMan > > > > > > > > > > > > > > > > On Sun, May 20, 2012 at 9:15 AM, Geneocide <[email protected]> wrote: > > > sorry post was breaking. Here's the link to the demo I tried to post. > > > > >https://code.google.com/apis/ajax/playground/?type=visualization#char... > > > > > > Also, the data is just strings and numbers > > > > > On May 19, 10:56 pm, ChartMan <[email protected]> wrote: > > > > You can definitely use controls regardless of where or how your data > is > > > > queried to the client. > > > > what type of data (column types) are you using and what is failing? > > > > On May 20, 2012 7:42 AM, "Geneocide" <[email protected]> wrote: > > > > > > > First, I apologize for being a newb, but I am. > > > > > > > I have a mysql database that I've been querying with PHP and > drawing > > > > > charts from the results after I format the results to JSON. It > looks > > > > > something like this.... > > > > > > > function drawYearlyChart() { > > > > > var jsonData = $.ajax({ > > > > > url: "getYearlyData.php", > > > > > dataType:"json", > > > > > async: false > > > > > }).responseText; > > > > > > > //create data table out of JSON > data > > > from > > > > > server > > > > > var data = new > > > > > google.visualization.DataTable(jsonData); > > > > > > > //instantiate and draw chart > > > > > var chart = new > > > > > > google.visualization.SteppedAreaChart(document.getElementById('yearlyChart' > > > )); > > > > > chart.draw(data); > > > > > } > > > > > Is there a way to use controls with this sort of data source? I've > > > > > been looking at the documentation and I can't see a way to do it. > When > > > > > I play around with what I got I don't get any helpful errors or > > > > > anything. Tips would be appreciated. > > > > > > > -- > > > > > 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. -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/dx_X0seqeHUJ. 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.
