How To Change The X Axis Labels In Excel

Change axis labels in a chart

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

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

Don't confuse the horizontal axis labels—Qtr 1, Qtr 2, Qtr 3, and Qtr 4, every bit 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 prison cell in the worksheet that contains the characterization text you want to change.

2. Blazon the text you want in each cell, and printing Enter.

   

   Every bit you change the text in the cells, the labels in the chart are updated.

To continue the text in the source data on the worksheet the manner information technology is, and only create custom labels, you can enter new label text that's independent of the worksheet information:

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

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

2. In the Axis label range box, enter the labels you desire to use, separated past commas.

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

Modify the format of text and numbers in labels

To change the format of text in category axis labels:

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

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

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

To modify the format of numbers on the value axis:

1. Correct-click the value axis labels y'all want to format.

2. Click Format Axis.

3. In the Format Axis pane, click Number.

   Tip:If y'all don't come across the Number section in the pane, make certain you've selected a value centrality (information technology'south usually the vertical centrality on the left).

   

4. Cull the number format options yous want.

   

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

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

   Annotation:Earlier you format numbers as percentages, make certain that the numbers shown on the chart have been calculated as percentages in the worksheet, or are shown in decimal format similar 0.ane. To calculate percentages on the worksheet, divide the amount by the total. For case, if you lot enter =10/100 and format the event 0.1 as a percent, the number is correctly shown every bit 10%.

Tip:An axis label is different from an axis title, which you can add to draw what'due south shown on the axis. Centrality titles are not automatically shown in a chart. To add them, see Add or remove titles in a chart.

Need more help?

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

Posted by: harrisfromment63.blogspot.com

Share this post