Exclude pivot table data from pivot chart?

I have a pivot table set up and some of the data that is on the table, I do
not want on the pivot chart. Reason being is that a graph of the data I am
speaking of does not make sense. Is there a way I can make a pivot chart
without these two columns of data being included? Thanks in advance for any
help.

The pivot chart displays what's in the pivot table. You could create
another pivot table, using the first pivot table as the source. Set it
up without the two columns, and create the chart from that.

coal_miner wrote:
> I have a pivot table set up and some of the data that is on the table, I do
> not want on the pivot chart. Reason being is that a graph of the data I am
> speaking of does not make sense. Is there a way I can make a pivot chart
> without these two columns of data being included? Thanks in advance for any
> help.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html