How to hide any percentages on the y axis above 100%

sabha

New Member
Joined
Oct 10, 2015
Messages
21
Hi,

I have a chart with multiple data lines. One of the data lines goes above 100% and so in order to see that line, I have to change my maximum.However, I am not allowed to visibly show any percentages above 100%. The data line still needs to be visible but just not the percentage.

How would I do that? And if that is possible, is there a VBA code for that? Because I have multiple charts as well. Please help! Thanks!
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,771
Hi

If I understand correctly the you don't want values above 100% displayed in the Y axis.

Use a format like:

[<=1]0%;""
 

Watch MrExcel Video

Forum statistics

Threads
1,095,359
Messages
5,444,005
Members
405,259
Latest member
charliechaz

This Week's Hot Topics

Top