Pivot Chart - Remove Variables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Is it possible to use a Pivot Chart with a Pivot Table as the data source
and select only part of the table to be charted. For instance i have 5
variables in a pivot report of which i want to chart only 2 in a graph from
that pivot table.

I don't want to copy and paste special then chart as i am after an
interactive chart that will adjust as my pivot report does.

If i de-select the ones i don't want through the key drop down it changes my
pivot report - which i dont want to happen.

Any suggestions would be most helpful.

M
 
Create another pivot table, based on the first one.
Base the pivot chart on the second pivot table, which you can store on a
hidden sheet.
Changing the pivot chart won't affect the first pivot table.
 
Back
Top