Remove series from pivot chart
 

I have a pivot table linked to an OLAP cube with 10 data series and have
created a chart from that data. However, I cannot remove any series from the
chart - the "remove" (and all other) buttons are greyed out in the chart.

What I need to do is have 3 charts in my sheet, each containg 3 series from
my main pivot table.

Any way to do that?

Thanx

Remove series from pivot chart
 

A pivot chart has to show all the data in the related pivot table, and it
cannot show data from elsewhere.

Make yourself a regular chart from the pivot table data. Select a blank cell
that's not touching the pivot table, and start the chart wizard. In step 2,
select data, click on the Series tab, and add your data one series at a
time.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Alexander Caravitis" <Alexander wrote
in message ...
I have a pivot table linked to an OLAP cube with 10 data series and have
created a chart from that data. However, I cannot remove any series from
the
chart - the "remove" (and all other) buttons are greyed out in the chart.

What I need to do is have 3 charts in my sheet, each containg 3 series
from
my main pivot table.

Any way to do that?

Thanx