Remove series from pivot chart

[Alexander Caravitis]

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

 

[Jon Peltier]

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