Quick summary
To change the Y-axis values in a Microsoft Excel chart, open the Format Axis panel via the Chart menu and adjust the Bounds and Major Units under the Vertical Axis settings. This lets you control the minimum, maximum, and interval values displayed on your chart's y-axis.
Steps
- Inside your Microsoft Excel worksheet, select the chart you wish to edit.
- Head over to the top menu bar and click the 'Chart' option.
- Choose 'Select Data' from the available options.
- Click the 'Format' tab to access the chart settings related to the y-axis values.
- Select 'Vertical Axis' from the list of options.
- Navigate to the Bounds section and change the default Minimum and Maximum values to edit the data range.
- 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 updated based on your input.
