Forum Discussion
Pivot Chart - viewing the data I want to see
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.
