How to make Y-axis go up to 100

Hello,

I have the following data which I have graphically represented, I wanted to ask how to make the vertical axis extend upto 100% (maximum possible percentage value), even though, none of the values in the actual data amount to 100%.

Thanks!

Click anywhere on the chart.

Double-click the y-axis, or activate the Format tab of the ribbon and select Vertical (Value) Axis from the Chart Elements drop-down.

This will activate the Format Axis task pane.

If necessary, select Axis Options and expand Axis Options below it.

Enter 100 in the Maximum box.

---
Best wishes, HansV
https://www.eileenslounge.com

19 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated April 5, 2025 Views 9,640 Applies to: