How To Change Sig Figs On Excel Graph Axis

Alter axis labels in a nautical chart

Excel for Microsoft 365 Word for Microsoft 365 Outlook for Microsoft 365 PowerPoint for Microsoft 365 Excel 2021 Word 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 chart you create, axis labels are shown below the horizontal (category, or "X") axis, next to the vertical (value, or "Y") centrality, and next to the depth axis (in a 3-D nautical chart). Your chart uses text from its source data for these centrality labels.

Don't misfile the horizontal axis labels—Qtr 1, Qtr 2, Qtr 3, and Qtr iv, as shown below, with the legend labels below them—East Asia Sales 2009 and East Asia Sales 2010.

Change the text of the labels

Click each cell in the worksheet that contains the label text y'all desire to change.
Type the text y'all desire in each jail cell, and press Enter.

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

To keep the text in the source information on the worksheet the fashion it is, and just create custom labels, yous tin can enter new label text that'south contained of the worksheet data:

Correct-click the category labels you want to modify, and click Select Data.

Right-click the category axis and Select Data

In the Horizontal (Category) Axis Labels box, click Edit.
In the Axis label range box, enter the labels you desire to utilise, separated by commas.

For case, type Quarter 1 ,Quarter 2,Quarter 3,Quarter iv.

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 y'all want to format, and click Font.
On the Font tab, choose the formatting options you want.
On the Character Spacing tab, cull the spacing options you want.

To alter the format of numbers on the value axis:

Correct-click the value centrality labels y'all want to format.
Click Format Axis.
In the Format Axis pane, click Number.

Tip:If y'all don't see the Number section in the pane, brand sure yous've selected a value centrality (it'southward ordinarily the vertical axis on the left).
Choose the number format options yous want.

If the number format you choose uses decimal places, you tin specify them in the Decimal places box.
To keep numbers linked to the worksheet cells, check the Linked to source box.

Annotation:Earlier you format numbers as percentages, make sure that the numbers shown on the nautical chart have been calculated as percentages in the worksheet, or are shown in decimal format like 0.one. To calculate percentages on the worksheet, divide the amount past the total. For case, if you lot enter =ten/100 and format the issue 0.1 as a percentage, the number is correctly shown every bit ten%.

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