Perhaps this post can help . . .

http://www.cellmatrix.net/index.php/...mbedded_charts

To have the charts appear in their own window, the code can be modified to
show the charts in a UserForm. Post back if you would like instructions on
that method.

--
John Mansfield
http://cellmatrix.net





"zephyr" wrote:

I have a worksheet with ten charts. Is there a way to hide the charts and
have a macro button so that the chart appears in its own window? The charts
should all be the same size. If this is possible could you provide a step by
step approach?

Many thanks and any help is appreciated.