View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Alexander Caravitis Alexander Caravitis is offline
external usenet poster
 
Posts: 1
Default 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