Google Charts - is content drill-down in a chart possible?
google-visualization, jquery
Solution
Yes, it is possible. Although there is no straight way to do it.
I too was looking for this and I figured out a way.
You must prepare a JSON string using PHP (or any other backend language). PHP should talk to the database recursively and generate the required Javascript literal syntax for every drilldown chart and embed it in a JSON format. Once the JSON string is ready, copy paste the JSON string into your HTML script tag. Add a click event handler to switch to the appropriate Javascript literal. Once the Datatable is ready call chart.draw().
You can have a look at this. Link to repository.
Problem
HighCharts has a really nice drilldown feature: http://www.highcharts.com/demo/column-drilldown - but I'm wondering if it's available in google charts visualization API? So far as I can tell, it's not possible - but let me describe my idea: On mouseover, a small pop-out window with additional information about the data is available. Is it possible to place a link in that? Because we have these mouseover events on the chart, perhaps it's possible to add a "click" event where we can do whatever we want with it? In this case, I'd either just have a click send the user to another URL, or possibly force the chart into a new chart animation (basically creating the drill down in this manor). I'm not too great with jQuery, so I'd appreciate some expertise here. Thanks!