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