Chart Macro

[zephyr]

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.

 

[John Mansfield]

Perhaps this post can help . . .

http://www.cellmatrix.net/index.php/site/analysis/name_hide_and_show_embedded_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.