Drill down through charts

  • Thread starter Thread starter simonguy
  • Start date Start date
S

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?
:confused:
 
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
 
Can you recommend the best course/book/CD that I can utilise in order
for me to learn VBA for Excel?
 
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
_______

Jon said:
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
Click to expand...
 
Back
Top