| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I update charts using macros
I have lot of charts (44 in total) in one sheet. The data for the charts are
linked to another spreadsheet. When I update the values the charts are not updated even though both files are open at the same time. It will only update if I manually re-visit the data ranges or close the file and re-open it. Is there are any why to telling (using macros) to update all the charts in the workbook? Thanks in advance Seng |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update Charts X-axis | Excel Discussion (Misc queries) | |||
| Macro to Update Charts Source Data | Charts and Charting in Excel | |||
| Charts won't update | Charts and Charting in Excel | |||
| Charts don't update when data changes | Charts and Charting in Excel | |||
| How do I update Excel 2000 macros to work in Excel 2002? | Excel Discussion (Misc queries) | |||
Threaded Mode
