Macro to update Chart
 

I'm trying to create a macro that will update a dashboard of charts by pushing a button. The data resides in the same excel file but different page and the dashboard contains approx 7 charts. The charts are updated quarterly and rather than having to go into each one and shift the source data I would like to automate it....any ideas? I'm a novice to macros!

Macro to update Chart
 

Why use a macro? Make dynamic charts:

Dynamic Charts - http://peltiertech.com/WordPress/dynamic-charts/

Dynamic and Interactive Charts (overview) -
http://peltiertech.com/Excel/Charts/Dynamics.html

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



lajohn63 wrote:
I'm trying to create a macro that will update a dashboard of charts by
pushing a button. The data resides in the same excel file but
different page and the dashboard contains approx 7 charts. The charts
are updated quarterly and rather than having to go into each one and
shift the source data I would like to automate it....any ideas? I'm a
novice to macros!