Pivot Chart won't refresh!
in [Charts]
|
From: srpd on 22 Jan 2010 12:30 After creating Pivot tables and charts, I added more data to the master sheet. Then selected a cell in a pivot table and hit Refresh. The screen bounced a little as the cell sizes changed but the data remained the same. What am I doing wrong?
From: Debra Dalgleish on 23 Jan 2010 20:57 Make sure all the new data is included in the pivot table source. There are instructions here for creating a dynamic data source for the pivot table: http://www.contextures.com/xlPivot01.html#Dynamic srpd wrote: > After creating Pivot tables and charts, I added more data to the master > sheet. Then selected a cell in a pivot table and hit Refresh. The screen > bounced a little as the cell sizes changed but the data remained the same. > What am I doing wrong? -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com
From: Robert Flanagan on 24 Jan 2010 08:33 You need to update the data range for the pivot table. I know in 97-2003 you would select any cell in the pivot table then Data, Pivot Table Report, and click the back button once. This lets you specify the new range. Not certain the steps in 2007 I actually use the Spreadsheet Assistant to do the above. Its a product I sell. It has a feature to expand the pivot data range and works in all Excel versions. Robert Flanagan http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "srpd" <srpd(a)discussions.microsoft.com> wrote in message news:E78CF5CA-8A67-4F40-BF59-81016A17BDB0(a)microsoft.com... > After creating Pivot tables and charts, I added more data to the master > sheet. Then selected a cell in a pivot table and hit Refresh. The screen > bounced a little as the cell sizes changed but the data remained the same. > What am I doing wrong?
From: srpd on 26 Jan 2010 10:28 That was it. Thanks! I found it in 2007. PivotTablesTools > Options > Change Data Source > Change Data Source "Robert Flanagan" wrote: > You need to update the data range for the pivot table. I know in 97-2003 > you would select any cell in the pivot table then Data, Pivot Table Report, > and click the back button once. This lets you specify the new range. Not > certain the steps in 2007 > > I actually use the Spreadsheet Assistant to do the above. Its a product I > sell. It has a feature to expand the pivot data range and works in all > Excel versions. > > Robert Flanagan > http://www.add-ins.com > Productivity add-ins and downloadable books on VB macros for Excel > > "srpd" <srpd(a)discussions.microsoft.com> wrote in message > news:E78CF5CA-8A67-4F40-BF59-81016A17BDB0(a)microsoft.com... > > After creating Pivot tables and charts, I added more data to the master > > sheet. Then selected a cell in a pivot table and hit Refresh. The screen > > bounced a little as the cell sizes changed but the data remained the same. > > What am I doing wrong? > > > . >
|
Pages: 1 Prev: Hide data labels with "0" values Next: Dynamically Scale Gantt Chart Time Scale |