Oct 22 2019 07:58 AM
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!
Oct 22 2019 08:29 AM
@acrisan Have you tried hiding the columns you don't want plotted? That or just remove them altogether.