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 ?