exceljockey
Member
Hi
I would like to be able to click on a bar from a bar chart, then a pie chart pops up somewhere to show the relevant data.
A better explanation: A bar chart could show sales in a shop - lets say there are 3 bars on the chart - one for drinks, one for food and one for magazines. If I click on the first bar for drinks, I want a pie chart to come up with all the different type of drinks and how much we sold of each.
Any ideas on where to start?
Thanks
EJ
I would like to be able to click on a bar from a bar chart, then a pie chart pops up somewhere to show the relevant data.
A better explanation: A bar chart could show sales in a shop - lets say there are 3 bars on the chart - one for drinks, one for food and one for magazines. If I click on the first bar for drinks, I want a pie chart to come up with all the different type of drinks and how much we sold of each.
Any ideas on where to start?
Thanks
EJ