Drill down through charts

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
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

simonguy wrote:

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?




------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

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 Peltier wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

simonguy wrote:

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?




------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/