Forum Discussion
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.
Hi Jeffrey
One option would be to make a copy of the Pivot table and remove the 2 unwanted columns for your chart, you could then use Slicers to control both Pivot Tables at the same time (assuming you have Excel 2010 or later).
i.e. one pivot table contains all the data you want to see and one controls your chart