How To Change The Horizontal Axis Labels In Excel

Alter axis labels in a chart

Excel for Microsoft 365 Word for Microsoft 365 Outlook for Microsoft 365 PowerPoint for Microsoft 365 Excel 2021 Give-and-take 2021 Outlook 2021 PowerPoint 2021 Excel 2019 Word 2019 Outlook 2019 PowerPoint 2019 Excel 2016 Word 2016 Outlook 2016 PowerPoint 2016 Excel 2013 Word 2013 Outlook 2013 PowerPoint 2013 More...Less

In a nautical chart you create, axis labels are shown beneath the horizontal (category, or "X") centrality, side by side to the vertical (value, or "Y") axis, and side by side to the depth axis (in a iii-D nautical chart). Your chart uses text from its source data for these axis labels.

Don't confuse the horizontal axis labels—Qtr i, Qtr 2, Qtr 3, and Qtr 4, as shown beneath, with the legend labels below them—East asia Sales 2009 and East Asia Sales 2010.

Change the text of the labels

1. Click each cell in the worksheet that contains the label text y'all desire to change.

2. Type the text y'all want in each cell, and press Enter.

   

   As you alter the text in the cells, the labels in the chart are updated.

To go along the text in the source data on the worksheet the mode information technology is, and just create custom labels, you can enter new label text that'south independent of the worksheet data:

1. Right-click the category labels you lot want to change, and click Select Data.

1. In the Horizontal (Category) Centrality Labels box, click Edit.

2. In the Centrality characterization range box, enter the labels yous want to use, separated past commas.

For example, type Quarter 1 ,Quarter 2,Quarter three,Quarter 4.

Change the format of text and numbers in labels

To modify the format of text in category axis labels:

1. Right-click the category axis labels you lot want to format, and click Font.

2. On the Font tab, choose the formatting options you want.

3. On the Grapheme Spacing tab, choose the spacing options you want.

To change the format of numbers on the value axis:

1. Right-click the value axis labels you want to format.

2. Click Format Centrality.

3. In the Format Axis pane, click Number.

   Tip:If y'all don't run across the Number section in the pane, make sure you've selected a value centrality (it's usually the vertical centrality on the left).

   

4. Choose the number format options yous desire.

   

   If the number format y'all choose uses decimal places, you tin can specify them in the Decimal places box.

5. To go on numbers linked to the worksheet cells, check the Linked to source box.

   Note:Before you format numbers equally percentages, brand sure that the numbers shown on the chart have been calculated equally percentages in the worksheet, or are shown in decimal format like 0.1. To calculate percentages on the worksheet, split the amount by the total. For example, if you enter =10/100 and format the consequence 0.1 every bit a pct, the number is correctly shown as 10%.

Tip:An axis label is different from an axis title, which you can add together to describe what's shown on the axis. Axis titles are non automatically shown in a chart. To add them, see Add or remove titles in a chart.

Demand more assist?

Source: https://support.microsoft.com/en-us/topic/change-axis-labels-in-a-chart-1c32436b-fb12-450b-aefa-cc7e4584456a

Posted by: daltonthisharm.blogspot.com

Share this post