displaying several charts, one at the time

[Guest]

I have several charts on the result sheet. I would like to create the
procedure which will display one chart after another, one at the time,
putting it in the middle of the screen, like the user form or message window.
In addition I would like to add the continue button to move to the next chart
to be displayed. Is it possible ?
I could put each chart on separate sheet but I prefer to keep them all on
one sheet.

Thanks for advice.

Tony

 

[R.VENKATARAMAN]

try this url

http://edferrero.m6.net/Content/ChartSelector.zip

 

[Jon Peltier]

Another approach:

http://peltiertech.com/Excel/Charts/ChartByControl.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______