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.
Just change the fill color of the bars you don't want to see to no fill and do some alignment work. Jeffrey Sbonik