Drill down through charts

[simonguy]

Is it possible to drill down through charts? i.e. by clicking on a
double line it will open up another linked chart which expands the
previous data series into another chart format?
I guess this must require VBA?

 

[Jon Peltier]

This takes VBA, and chart events to capture the click or double click.
The easiest thing would be to have the other charts present in the
workbook, and the event notices which point was clicked, then activates
the appropriate chart.

- Jon

 

[simonguy]

Can you recommend the best course/book/CD that I can utilise in order
for me to learn VBA for Excel?

 

[Jon Peltier]

Simon -

This one is good, Power Programming, by John Walkenbach:

http://j-walk.com/ss/books/bookxl19.htm

Debra Dalgleish maintains an exhaustive list of books:

http://contextures.com/xlbooks.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

This takes VBA, and chart events to capture the click or double click.
The easiest thing would be to have the other charts present in the
workbook, and the event notices which point was clicked, then activates
the appropriate chart.

- Jon