Remove series from Pivot Chart

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

In Excel 2007, is it possible to remove a series of values from a Pivotchart?
I have a pivot table with 1 report filter, 1 row label series, and 6 value
series all of which have been formatted and are displayed in a table. Now I
want to be able to generate a pivot chart based on that data (which I have
done) but now wish to remove one of the series from only the chart and not
from the original table? Can this be done? If so how would I proceed since
clicking on the select data function on the chart does not let me remove any
of the data series?
 
You can't remove the series, as Andy points out, but you can format a series
in the chart so it's invisible (depending on chart type: no border, no fill,
no lines, no markers).

- 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

Similar Threads

Remove series from pivot chart 1
Chart SERIES OFFSET 3
Pivot Chart Time Series work around? 1
Excel 2007 multiple data series charts 1
Why won't data hide? 3
Pivot table charting 3
Pivot chart 1
Show Series Name 5

Back
Top