Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Changing Data Sources
Hi,
I have an excel worksheet with several pivot tables and charts within it. The pivot tables and charts are getting there data from the same table but showing the results in different ways. If I wanted to change the data source so the pivot tables and charts feed from another table how do I do this so it changes it for all the pivot tables and charts at once and refreshes the data. Basically I want to create a template within excel showing pivoted data and chart results but I want to keep changing the data source from which the pivots and charts feed from. Thanks Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Record changing cell data into a column or range | Excel Worksheet Functions | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
Retaining data permanently from periodic changing data in workshe. | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) |