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

try this url

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


Tony wrote in message
...
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

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