How to Change the Y-Axis Values in Microsoft Excel Charts
- George Apostolov
How to Change the Y-Axis Values in Microsoft Excel Charts: step-by-step guide
Inside your Microsoft Excel worksheet, select the chart you wish to edit.
After that, head over to the top menu bar and click 'Chart'.
Choose 'Select Data' from the available options.
Next, click the 'Format' tab to access the chart settings related to the y-axis values.
Select 'Vertical Axis' from the list of options.
From there, you can now change the y-axis values of the selected chart. To edit the data range, navigate to the Bounds section and change the default Minimum and Maximum values.
Next, change the default value of Major Units under the Units section to edit the data interval.
After completing these steps, the y-axis values of the selected chart will be changed based on your input.
Quick answer: To change the Y-axis values in Microsoft Excel charts, select the chart, go to the top menu bar, click 'Chart', and choose 'Select Data'. Next, click the 'Format' tab, select 'Vertical Axis', and update the Minimum, Maximum, and Major Units values in the Bounds and Units sections.
About this Microsoft tutorial
Modify the vertical axis values, data range, and intervals in your Microsoft Excel charts by updating the bounds and units settings. This guide shows how to change the Y-Axis Values in Microsoft Excel Charts in 8 steps, starting with "Inside your Microsoft Excel worksheet, select the chart you wish to edit" and finishing with "After completing these steps, the y-axis values of the selected chart will be changed b...". The interactive demo above is a click-through copy of the real Microsoft interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to change the Y-Axis Values in Microsoft Excel Charts?
8 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Microsoft data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Microsoft and Excel. Related guides: How to Clear Cell Formatting in Microsoft Excel, How to Color Every Other Row in Microsoft Excel and How to Combine Cells in Microsoft Excel. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
