I've got 4 distinct sets of data in a pivot table (e.g., costs, sales,
products, inquiries) that I'd like to display in 4 separate charts and then
be able to select a different grouping from the 1 pivot table. If I put all
the fields in 1 pivot table, the chart tries to display all the data types
which can't be put in 1 chart due to the different units for each set of
data. If I create 4 separate tables for each type of data, the charts work
great, but now to change a selection, I have to go to 4 different pivot
tables.

Any ideas ?

You can make regular charts from a pivot table. Select a blank cell not
touching the pivot table and start the chart wizard. In step 2, click on the
Series tab, and add each series to the chart by selecting the individual X
and Y values and series name. If the pivot table retains its shape, these
charts will update just fine when you change the pivot table, but if the
pivot table adds or removes rows or columns, the charts will need their data
ranges adjusted, which is probably more work than updating individual pivot
tables.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______


"rclough" wrote in message
...
I've got 4 distinct sets of data in a pivot table (e.g., costs, sales,
products, inquiries) that I'd like to display in 4 separate charts and
then
be able to select a different grouping from the 1 pivot table. If I put
all
the fields in 1 pivot table, the chart tries to display all the data types
which can't be put in 1 chart due to the different units for each set of
data. If I create 4 separate tables for each type of data, the charts
work
great, but now to change a selection, I have to go to 4 different pivot
tables.

Any ideas ?