If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
refreshing charts
In EXCEL 2007 check the folllowing:-
Office Button Excel Options Formulas (on left hand side) Calculation options - i here make sure that Workbook Calculation is set to Automatic. I do not see the problems that you see. If my comments have helped please hit Yes. Thanks. "Yossi evenzur" wrote: 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? |
#3
|
|||
|
|||
refreshing charts
Yes, it's on automateded mode but still refreshing partcialy
"trip_to_tokyo" wrote: In EXCEL 2007 check the folllowing:- Office Button Excel Options Formulas (on left hand side) Calculation options - i here make sure that Workbook Calculation is set to Automatic. I do not see the problems that you see. If my comments have helped please hit Yes. Thanks. "Yossi evenzur" wrote: 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? |
#4
|
|||
|
|||
refreshing charts
OK, sorry cannot think of anything else; perhaps others can?
Which version of EXCEL are you on? "Yossi evenzur" wrote: Yes, it's on automateded mode but still refreshing partcialy "trip_to_tokyo" wrote: In EXCEL 2007 check the folllowing:- Office Button Excel Options Formulas (on left hand side) Calculation options - i here make sure that Workbook Calculation is set to Automatic. I do not see the problems that you see. If my comments have helped please hit Yes. Thanks. "Yossi evenzur" wrote: 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 | |
Display Modes | |
|
|