Drill Down Charts

[SUMA]

Is there anything in Excel that can be used to Drill Down from one Chart into another Chart. For example for a chart of all accounts and then double click on one bar and get a chart of that subset which was clicked
thanks

 

[Ed in Aus]

Pivot table

 

[tusharm]

I would love to learn how to double click on a data element in a Pivot Chart to 'drill down' to its components.

Pivot table

 

[tusharm]

See
PivotChart Drill-down
http://www.tushar-mehta.com/excel/software/pivotchart_drilldown/

Is there anything in Excel that can be used to Drill Down from one Chart into another Chart. For example for a chart of all accounts and then double click on one bar and get a chart of that subset which was clicked
thanks

 

[SUMA]

I do not want to get an addon and I would like to just drill from one chart into another not from pivot table. Is there another one

 

[tusharm]

Why do you think I wrote the add-in? If the capability were available in Excel (and I knew about it) the last thing I would do is waste my time and energy on an add-in that I have to maintain for the foreseeable future! {grin}

As I asked Ed in Aus will show us how it can be done w/o code.

I do not want to get an addon and I would like to just drill from one chart into another not from pivot table. Is there another one