Formatting Chart Axes (Mac)

How to Change the Intervals on an X-Axis in Excel

When you fix both ends of the axis, the axis range is determined by the values you specify. Send No thanks. The first axis label displays, then Excel skips labels until the number of your interval, and continues on in this pattern. What We Do. Right-click control-click on Mac the axis you want to edit and select Edit Axis. Date-based Axis 1.

Changing the Scale of a Graph

Click OK. Open the Excel file where you graph is located. Was this article helpful? Right-click control-click on Mac the continuous field in the view that is associated with axis you want to show, click its drop down menu, and then click Show Header. If the axis is not at the bottom of the plot area e. When you clear the Include zero check box, the axis range adjusts to show only the range of values in the data.

To change the interval of tick marks and chart gridlines, for the Major unit or Minor unit option, type a different number in the Major unit box or Minor unit box. To change the scale of other axes in a chart, see Change the scale of the vertical value axis in a chart or Change the scale of the depth series axis in a chart. When you right-click a header, you will see this menu:.

The horizontal category axis, also known as the x axis, of a chart displays text labels instead of numeric intervals and provides fewer scaling options than are available for a vertical value axis, also known as the y axis, of the chart. To reverse the order of categories, expand Axis Options , and then select the Categories in reverse order check box.

Click the x-axis or y-axis directly in the chart and then click Horizontal Axis or Vertical Axis on its drop-down list. In web authoring, you can click the arrow button on an axis, and then select Edit Axis.

After you perform these steps, when you add data to columns B and C, the chart updates automatically to show the new data see on the top of this screen. However, you can customize the scale to better meet your needs. If you have dates as your categories, but don't want the information to appear chronologically, click the radio button next to "Text axis.

Edit your chart's axes

For both Major and Minor tick marks , select from one of the following options:. On the Format tab, in the Current Selection group, click the arrow in the box at the top, and then click Horizontal Category Axis. Then, indicate the new orientation by clicking the desired vertical alignment in the Vertical Alignment drop-down list box and desired text direction in the Text Direction drop-down list.

When you create a chart, the X-Axis, also called the horizontal or category axis, establishes the categories that Excel uses to break up and display the data.