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!!!!
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!!!!