Reset Chart’s Value (Y) Axis Help - SPC for Excel (2024)

FAQs

Reset Chart’s Value (Y) Axis Help - SPC for 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.

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.

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.

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.

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.

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 change the Y axis position 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.”

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

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.

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.