refreshing charts
in [Charts]
|
From: Yossi evenzur on 14 Feb 2010 02:43 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?
From: trip_to_tokyo on 14 Feb 2010 03:16 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?
From: Yossi evenzur on 15 Feb 2010 07:25 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?
From: trip_to_tokyo on 15 Feb 2010 10:59 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?
|
Pages: 1 Prev: Placing an arrow on the series line in a line chart Next: Live data capture and charting speed |