View Single Post
  #3   Report Post  
Jon Peltier
 
Posts: n/a
Default

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/
_______

Tony wrote:

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