Change axis labels in a chart (2024)

FAQs

How do I change the axis labels on a chart? ›

Right-click the category labels to change, and click Select Data. In Horizontal (Category) Axis Labels, click Edit. In Axis label range, enter the labels you want to use, separated by commas. For example, type Quarter 1,Quarter 2,Quarter 3,Quarter 4.

Click anywhere in the chart. This displays the Chart Tools, adding the Design and Format tabs. On the Format tab, in the Current Selection group, click the arrow in the Chart Elements box, and then click the axis that you want to select.

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.

Highlight and Right-Click x-axis the graph. Go to and Select to the “Format”. In the Format Axis pane, under “Axis Options”, click third icon from the left(Size and Properties). Under the Alignment section, in “Text Direction”, enter the angle you want.

Hold down the CTRL or SHIFT key to select multiple labels, and apply an attribute to more than one label. You can also hold down your mouse key and drag to create a "lasso" around several labels to select several labels at once.

Go to Home > Cells > Format. Under Cell Size, select AutoFit Row Height. Tip: To quickly autofit all rows on the worksheet, select Select All, and then double-click the boundary below one of the row headings.

If you want an M, indicating Millions, to appear at the end of the labels, enter this in the FORMAT CODE box: $#,##0.0,,”M”. Anything in the quotes will display as text after your data. The best part is that if your data changes, the numbers will update, formatting included!

Under Chart Tools, on the Design tab, in the Data group, click Select Data. In the Select Data Source dialog box, in the Legend Entries (Series) box, click the data series that you want to change the order of. Click the Move Up or Move Down arrows to move the data series to the position that you want.

With Pyplot, you can use the xlabel() and ylabel() functions to set a label for the x- and y-axis.

To avoid spacing problems caused by lengthy chart or axis titles in a chart, you can change the way that titles are positioned. You can drag the titles to the location that you want, or you can select a specific position for the titles.

How do I move axis labels in Word? ›

Click the label on the horizontal axis and expand "Labels" from the Format Axis sidebar. Click the "Label Position" drop-down menu and select "Low" to move the label to the bottom of the chart. Alternatively, select "High" to move it to the top or "None" to remove it entirely.