Clickable Drilldown Pie Charts

[excelmax]

I'm building a workbook wherein I need pie charts or pies of a chart. For example,


First Chart shows Revenue from meat, fruit, dairy, breads

<click on dairy>

Another Chart now shows Revenue from milk, eggs, cheese, butter

<click on cheese>

Another Chart now shows Revenue from Cheddar, Mozerella, Colby, Swiss

(and if possible, maybe some way to click back out to each higher level)


Can anyone please guide me how I could get this done?


Thanks!

 

[jason]

First off, welcome to CHANDOOOOOOOOOO.ORG!!!


If you had this data in a PivotTable a PivotChart would be one solution... you could even use the Slicer Tool to change which Category (dairy, cheese, etc) you want to view. (Slicers are only in Excel 2010)


i vote for PivotTbl/PivotChart


do you have a sample of your spreadsheet you can share? this would allow us to see how you have your data setup (this alone could be a huge)

 

[Trader273]

Also, might want to reconsider using pie charts as they can be easily misunderstood by the target audience

 

[Hui]

Excelmax


You may also want to have a look at Youtube

Search for "excel drill down chart"


There are a few examples of ways to add Drill Down capabilities to charts

http://www.youtube.com/results?search_query=excel+drill+down+chart