# How to Change the Y-Axis Values in Microsoft Excel Charts

> 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.

Canonical: https://livedemo.ai/tutorials/how-to-change-the-y-axis-values-in-microsoft-excel-charts/
Apps: Microsoft, Excel
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a327aab56e05a00fd61e3/preview?step=1

## Steps

1. Inside your Microsoft Excel worksheet, select the chart you wish to edit.
2. After that, head over to the top menu bar and click 'Chart'.
3. Choose 'Select Data' from the available options.
4. Next, click the 'Format' tab to access the chart settings related to the y-axis values.
5. Select 'Vertical Axis' from the list of options.
6. 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.
7. Next, change the default value of Major Units under the Units section to edit the data interval.
8. After completing these steps, the y-axis values of the selected chart will be changed based on your input.