Forum Discussion
Jeffrey Sbonik
Jan 27, 2017Copper Contributor
Pivot Chart Hiding Data
I am working on a pivot table and I have all of the data that I need there. When I use the pivot chart it pulls in all of the data columns, which I only want 3 of the 5 columns to pull into chart.
SergeiBaklan
Jan 28, 2017Diamond Contributor
Jeffrey, for my knowledge you can't do that as far as your pivot chart is linked to the pivot table, without deleting fields in both. IMHO, the easiest way to break that link is to create the pivot chart independently from pivot table. Most probably your data is in data model (default option when you create pivot table), if so insert power chart from Power Pivot menu, without creating another pivot table. If you don't work with data model for any reason, second pivot table could be created in separate worksheet (which you may hide later on) to create the power chart on it.