![2017 2017](/uploads/1/2/5/4/125496448/908929020.png)
Tip You can also change the horizontal alignment of axis labels, by clicking the axis, and then click Align Left, Center, or Align Right on the Home toolbar. Change text of category labels You can change the text of category labels on the worksheet, or you can change them directly in the chart. Hello, I'm using Excel 2007 trying to change the horizontal axis labels for a line chart. In the select data source dialog box I select edit then enter the range of cells I want to use for axis labels, click o.k, and those cells are active selections.
Excel for Office 365 Word for Office 365 Outlook for Office 365 PowerPoint for Office 365 Excel 2019 Word 2019 Outlook 2019 PowerPoint 2019 Excel 2016 Word 2016 Outlook 2016 PowerPoint 2016 Excel 2013 Word 2013 Outlook 2013 PowerPoint 2013 In a, axis labels are shown below the horizontal (category) axis, next to the vertical (value) axis, and next to the depth axis (in a 3-D chart). Your chart uses text from its source data for these axis labels, but you can change that. Don't confuse the horizontal axis labels—Qtr 1, Qtr 2, Qtr 3, and Qtr 4, as shown below, with the legend labels below them—East Asia Sales 2009 and East Asia Sales 2010. To change the text of category labels in the source data on the worksheet:. Click each cell in the worksheet that contains the label text you want to change. Type the text you want in each cell, and press Enter. As you change the text in the cells, the labels in the chart are updated.
To keep the text in the source data on the worksheet the way it is, you can enter new label text that's independent of the worksheet data:. Right-click the category labels you want to change, and click Select Data.
In the Horizontal (Category) Axis Labels box, click Edit. In the Axis label range box, enter the labels you want to use, separated by commas. For example, type Quarter 1,Quarter 2,Quarter 3,Quarter 4. Change the format of text and numbers in labels To change the format of text in category axis labels:.
Right-click the category axis labels you want to format, and click Font. On the Font tab, choose the formatting options you want.
On the Character Spacing tab, choose the spacing options you want. To change the format of numbers on the value axis:. Right-click the value axis labels you want to format. Click Format Axis. In the Format Axis pane, click Number.