Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
refreshing charts
Hi
I have several excel workbooks with charts and pivot charts, every few days i have to add few new entries to the tables\pivot tables the charts are associated with. the problem is that the charts aren't updated, i have to manually go to each chart and modify the range. in the pivot charts it's even more strange since only part of the chart is rfereshed when i click the refresh button so i have to manually chnage the source ranges for each charts. i have about 20 charts to update and i don't want to write a macro for this. is there any other option to automatically referesh? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Charts - refreshing clears my chart formatting | Charts and Charting in Excel | |||
NOW() and SECOND() not refreshing | Excel Worksheet Functions | |||
How can I stop charts from refreshing when changing source data? | Charts and Charting in Excel | |||
Refreshing several pivot charts with one move | Charts and Charting in Excel | |||
refreshing charts | Charts and Charting in Excel |