| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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!
|
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How may I macro update a normal distribution chart from new data? | Charts and Charting in Excel | |||
| Update Chart Source (w/macro?) | Excel Worksheet Functions | |||
| Macro to Create a Chart and Update it Automatically | Charts and Charting in Excel | |||
| Update Chart Macro | Charts and Charting in Excel | |||
| Macro to Update Chart | Charts and Charting in Excel | |||
Linear Mode
