FAQs
On the Format tab, in the Current Selection group, click Format Selection. Under Axis Options, do one or both of the following: To change the interval between axis labels, under Interval between labels, click Specify interval unit, and then in the text box, type the number that you want.
How do I change the Y axis value in Excel? ›
How to change the Y-axis values in Excel
- Select the axis. Use your cursor to navigate to and select the Y-axis being changed. ...
- Open the "Select Data" menu. ...
- Select "Edit" under "Legend Entries (Series)" ...
- Enter your data range in the "Series Value" box. ...
- Select the chart. ...
- Open "Select Data" ...
- Click "Switch Row/Column" ...
- Press "OK"
How do I put the Y axis back in Excel? ›
Add or remove a secondary axis in a chart in Excel
- Select a chart to open Chart Tools.
- Select Design > Change Chart Type.
- Select Combo > Cluster Column - Line on Secondary Axis.
- Select Secondary Axis for the data series you want to show.
- Select the drop-down arrow and choose Line.
- Select OK.
How do I change the Y axis spacing in Excel? ›
On the Format tab, in the Current Selection group, click Format Selection. Under Axis Options, do one or both of the following: To change the interval between axis labels, under Interval between labels, click Specify interval unit, and then in the text box, type the number that you want.
How to change y-axis values in sheet? ›
You can format the labels, set min or max values, and change the scale.
- On your computer, open a spreadsheet in Google Sheets.
- Double-click the chart you want to change.
- At the right, click Customize.
- Click Vertical axis.
- Make the changes you want.
How do I manually change the Y axis labels in Excel? ›
Right-click the category labels to change, and click Select Data. In Horizontal (Category) Axis Labels, click Edit. In Axis label range, enter the labels you want to use, separated by commas.
How do I reset the axis in Excel? ›
Reset Chart's Value (Y) Axis Help
- Select the chart. ...
- Select “Actions” in the “Control Charts” panel on the SPC for Excel ribbon to display the Control Chart Actions form.
- Select the “Rest chart's value axis” option.
- Select OK on the “Control Chart Actions” form.
How to select y-axis data in Excel? ›
Right-click on the top of the column containing the x-data and drag your mouse to the bottom of the column to select it. Hold down the control key (command on a Mac) then do the same for the y-axis data column.
How do you reverse axis values in Excel? ›
On the Format tab, in the Current Selection group, click Format Selection. In the Axis Options category, do one of the following: For categories, select the Categories in reverse order check box. For values, select the Values in reverse order check box.
How to change y-axis value range in Excel? ›
Right-click the axis then select Format Axis in the menu. The Format Axis panel appears on the right side of the window. Under Axis Options in the Format Axis panel, set the minimum and maximum axis values by entering a value in the Minimum and Maximum boxes under Bounds.
Right Click > Format Axis.
- Then, to move the axis to the left, change Vertical Axis Crosses to Automatic.
- If you want to move the axis to the right, change the Vertical axis cross to At Maximum.
How do you set the Y axis interval in Excel? ›
To change the beginning and ending or minimum and maximum values of your Y-Axis, go to the “Axis Options -> Bounds” section. Type a new number in the “Minimum” and “Maximum” boxes. If you need to revert the change, click on “Reset.”
How do I change the Y axis value in numbers? ›
Select the chart. Click Axis at the top of the Format sidebar on the right, then click Value (Y) or Category (X), depending on the axis you want to modify (y or x).
How do you change the max value Y axis in Excel? ›
Select the axis on the chart. Right-click the axis then select Format Axis in the menu. The Format Axis panel appears on the right side of the window. Under Axis Options in the Format Axis panel, set the minimum and maximum axis values by entering a value in the Minimum and Maximum boxes under Bounds.
How do I flip the axis in Excel? ›
On the Format tab, in the Current Selection group, click Format Selection. In the Axis Options category, under Axis Options, select the Series in reverse order check box.