I have several charts of data against a year group in school, so we have 5 bars in the bar chart.
I would like to be able to make the bars in the bar chart, all of different colours, into links to split the data into subgroups, so I have year7 data, year 7 has 7 tutor groups, 7A 7B 7H 7K 7M 7S 7T.
when I SHOW THE GRAPH OF THE POINTS OF ALL THE YEAR GROUPS, , If I click on the bar for year 7, I would like to see the graph for year 7, grouped by tutor groups, also I would like to be able to drill down further to split the tutor group into the sexes, and then split the sexes into the individual pupils, all by clicking on the charts.
Can I do this?
If so, pointers please.
If I get it to work, I will do a howto for it.
Cheers
G