Best Horizontal Axis Labels
In the Axis label range box enter the labels you want to use separated by commas.
Horizontal axis labels. In Excel chart Axis labels are displayed horizontally if you want to change X Axis Labels direction from horizontal to vertical. And you can do as follows. Type the labels that you want to use separated by commas for example Division A Division B Division C.
In the Select Data Source dialog box under Horizontal Categories Axis Labels click Edit. First off you have to click the chart and click the plus icon on the upper-right side. How to achieve it.
In the drop-down menu we will click on Axis Titles and subsequently select Primary Horizontal. Our goal is to change the x-axis so that you can delete the x values and replace them with the new values. Group two-level axis labels with Pivot Chart in Excel.
However you can specify the following axis options. Select the source data and then click the Insert Column Chart or Column Column on the Insert tab. Figure 3 How to label axes in Excel.
And the Format Axis pane will open. In the Axis label range box do one of the following. Now the new created column chart has a two-level X axis and in the X axis date labels are grouped by fruits.
See below screen shot. Interval between tick marks and labels. For example type Quarter 1Quarter 2Quarter 3Quarter 4.