View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Remove series from Pivot Chart

Hi,

The charts are tables are linked. Change in one will affect the other.

You can create regular charts based on pivot table results. See Jon's
article.
http://peltiertech.com/WordPress/200...-pivot-tables/

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Bob" wrote in message
...
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?