Linking two charts in saparete worksheet to show its compone

sol95

New Member
Joined
Oct 10, 2006
Messages
19
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!!!!
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,028
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!!!!
 

Watch MrExcel Video

Forum statistics

Threads
1,114,385
Messages
5,547,650
Members
410,805
Latest member
Ginoji
Top