Home |
Search |
Today's Posts |
#1
|
|||
|
|||
pivot table
Dear Debra,
Could you please help me to solve this problem? I need to make a 4 quarts rolling chart. The chart data source is from a Pivot table. Pivot table data source is updated via a link with external data source. When External Data Source is updated, a new quarter Q2-07 comes in ,Q2-06 will be out, so there will be always 4 quarts data in the external data source. Pivot Table Data Source will be updated via a link with External data. My problem is every time new colum of quartly data comes in, pivot table is not showing the new data. I have to manuelly go into pivot table layout, and drag sum of new quart data into data area. I have selected Refresh on open in Pivot Table Option. Could you please help me to make it happen automatically? Many thanks in advance. YingRui Yang |
#2
|
|||
|
|||
If the quarters are field names, I don't know of any way to add them to
the data area automatically. You could probably use programming to add new fields when the workbook is opened. YingRui Oliviero wrote: Dear Debra, Could you please help me to solve this problem? I need to make a 4 quarts rolling chart. The chart data source is from a Pivot table. Pivot table data source is updated via a link with external data source. When External Data Source is updated, a new quarter Q2-07 comes in ,Q2-06 will be out, so there will be always 4 quarts data in the external data source. Pivot Table Data Source will be updated via a link with External data. My problem is every time new colum of quartly data comes in, pivot table is not showing the new data. I have to manuelly go into pivot table layout, and drag sum of new quart data into data area. I have selected Refresh on open in Pivot Table Option. Could you please help me to make it happen automatically? Many thanks in advance. YingRui Yang -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
pivot table | Excel Worksheet Functions | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |