Pivot Table Question

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

Hello.

I'm using Excel 2000.

I've created some pivot tables for reporting purposes. I
intend to use them to replace old fashioned charts and
tables that are manually keyed summary data.

I need to keep the transition to the new spreadsheet as
unobtrustive as possible for my less technical users, so
that they have the same charts that they're used to.

The problem with that is, I need to create seven charts.
I want to use the same pivot table (which pulls data from
Access) for each chart, but I want each chart to have
different categories, page fields, series, etc. Sometimes
my data is grouped by week, and other times by month.

Right now I have a seperate pivot table for each chart
that I need, which is obviously redundant. Is there a way
to make the modifications in pivotcharts not change the
layout of the source pivottable? Or are there any other
solutions?

Thank you.

-Brad
 
Instead of creating separate PivotTables and charts, you could record a
macro as you rearrange the fields, and print each variation.
 
Back
Top