If I understand what you are asking then NO, there is no way to do this in the API. However you can use a very simple drop down (<select>) which allows the user to select which column to use.
HTH ChartMan On Sun, May 20, 2012 at 6:52 PM, Geneocide <[email protected]> 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 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.
