Linking two charts in saparete worksheet to show its compone

[sol95]

Hi all,

This is to ask some question.
Currently I have several charts created in separate work sheet.
Say Chart A is for Jan sales figures, Chart B is for Feb sales figure and so on and finally I have a Chart X to show total of those figures.

Is there any way that I can link these charts to show Chart X to show its components of other Charts for its sum.
In other words, If you click the some part of line graph in the Chart X, it will automaticlly show the linked charts.

Does it make sense?

Help me...if anyone knows it would be great!!!!

 

[tusharm]

Re: Linking two charts in saparete worksheet to show its com

I am not sure what exactly you want but based on my understanding...

If your data are organized in a form compatible with a PivotTable, you could create a *single* chart that supports drill-down capability. At the top level, show the summary chart. Click any component to see the details. To accomplish this, use the add-in
PivotChart Drill-down
http://www.tushar-mehta.com/excel/software/pivotchart_drilldown/index.html

Hi all,

This is to ask some question.
Currently I have several charts created in separate work sheet.
Say Chart A is for Jan sales figures, Chart B is for Feb sales figure and so on and finally I have a Chart X to show total of those figures.

Is there any way that I can link these charts to show Chart X to show its components of other Charts for its sum.
In other words, If you click the some part of line graph in the Chart X, it will automaticlly show the linked charts.

Does it make sense?

Help me...if anyone knows it would be great!!!!