Next we want to make some changes to the percentage numbers on the Y (vertical) axis.
1. Right click the vertical (value) axis. Select Format Axis. This opens the Format Axis pane.
2. Click Number from the list of options. The commands in this section of the Format Axis pane are used to format numbers that appear on the selected axis of the chart.
3. Click in the Decimal places input box and change the value to 1.
4. Select Axis Options. Change the Minimum Bound to .05 to make the differences in the columns more dramatic. The Format Axis pane should match Figure 4.28.
5. Click the Close button at the top of the Format Axis pane.
6. Save your work.
https://openoregon.pressbooks.pub/beginningexcel/chapter/4-2-formatting-charts/