Exclude pivot table data from pivot chart?

C

coal_miner

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.
 
D

Debra Dalgleish

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.
 
B

billy_bags

I have a similar issue - I find the pivot chart doesn't display in the manner
I want it to and I can't seem to configure it in the way I can an ordinary
table.
I just want to configure the chart as I would be able to in an ordinary table.
 
E

Ed Ferrero

billy_bags said:
I have a similar issue - I find the pivot chart doesn't display in the
manner
I want it to and I can't seem to configure it in the way I can an ordinary
table.
I just want to configure the chart as I would be able to in an ordinary
table.

Another nice way to build a 'normal' chart from a Pivot Table is to use this
small macro.

Sub GetPivotDataToggle()
Application.GenerateGetPivotData = Not Application.GenerateGetPivotData
End Sub

Run the macro once...
- Charts behave normally
- Formula references to a PT are normal

Run the macro again...
- build Charts as Pivot Charts
- Formula references to PT are GETPIVOTDATA(...

Ed Ferrero
http://www.edferrero.com
 

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