Pivot Chart - viewing the data I want to see

Copper Contributor

Hi all, 

 

I have a pivot table which has 4 columns, and I'm only interested in 2. The two columns are the percentages.  When I create a chart it shows the numbers. How can I ignore the numbers columns and focus on only the percentages in the y axis. In the X axis, I would like to see the rows (which are already displaying). Please see the attached photo. 

 

 

Thank you!

1 Reply

@acrisan Have you tried hiding the columns you don't want plotted? That or just remove them altogether.