Remove series from pivot chart

  • Thread starter Alexander Caravitis
  • Start date
A

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top