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

[sabha]

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!

 

[pgc01]

Hi

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

Use a format like:

[<=1]0%;""

 

[sabha]

Thank you this worked!!!

 

[pgc01]

You're welcome. Thanks for the feedback.