How to add axis labels in microsoft word

Axis titles aren't automatically shown in a chart. To learn how to add them, see Add or remove titles in a chart. To learn more about legends, see Add and format a chart legend.

For example, type Quarter 1 ,Quarter 2,Quarter 3,Quarter 4. Right-click the category axis labels you want to format, and then select Font. Right-click the value axis labels you want to format, and then select Format Axis. Tip: If you don't see the Number section in the pane, make sure you've selected a value axis it's usually the vertical axis on the left. Tip: If the number format you choose uses decimal places, you can specify them in the Decimal places box.

To keep numbers linked to the worksheet cells, select the Linked to source check box. Note: Before you format numbers as percentages, make sure that the numbers shown on the chart have been calculated as percentages in the worksheet, or are shown in decimal format like 0. To calculate percentages on the worksheet, divide the amount by the total. Add or remove titles in a chart.

Add data labels to a chart. Available chart types in Office. 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. Use new text for category labels in the chart and leavesource data text unchanged. Right-click the category labels to change, and click Select Data.

In Axis label range , enter the labels you want to use, separated by commas. On the Font tab, pick the formatting options you want. On the Character Spacing tab, pick the spacing options you want. In the Format Axis pane, select Number.

Need more help? Expand your skills. Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical.

Not enough information. Not enough pictures.