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 |
Exclude pivot table data from pivot chart?
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. "Debra Dalgleish" wrote: 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 |
Exclude pivot table data from pivot chart?
In his article here, Jon Peltier describes how to make a regular chart
from pivot table data: http://pubs.logicalexpressions.com/P...cle.asp?ID=553 billy_bags wrote: 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. "Debra Dalgleish" wrote: 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 Contextures http://www.contextures.com/tiptech.html |
Exclude pivot table data from pivot chart?
"billy_bags" wrote in message
... 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 |
All times are GMT +1. The time now is 09:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com