ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Chart Macro (https://www.excelbanter.com/charts-charting-excel/168529-chart-macro.html)

zephyr

Chart Macro
 
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

Chart Macro
 
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.



All times are GMT +1. The time now is 12:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com