April 10, 2025
HansV MVP - Ashish Mathur - Andreas Killer - Riny_van_Eekelen - Jim_ Gordon ✅
Ask a new question
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.
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.
Thanks for your feedback.