Rotate Axis labels

This post will guide you how to rotate axis labels in Excel 2007/2003/2016. How do I change the text direction of the vertical axis label to rotate all text 270 in Chart in Excel. How to rotate X Axis labels in Chart in Microsoft Excel 2013.

1. Rotate Axis labels

In Excel chart, Axis labels are displayed horizontally, if you want to change X Axis Labels direction from horizontal to vertical. How to achieve it. Just do the following steps:

Step1: right click on the X Axis label, and select Format Axis from the popup menu list. And the Format Axis pane will open.

rotate axis labels1

Step2: click the Size & Properties button in the Format Axis pane.

rotate axis labels2

Step3: click Text direction list box, and choose Vertical from the drop down list box. Then close the Format Axis pane.

rotate axis labels3

Step4: the X Axis text has been rotated from horizontal to vertical.

rotate axis labels4

Your axis labels should now be rotated in the direction you chose.

For Excel 2007/2010:

You need to do the below steps to rotate Axis labels:

#1 right click on the X Axis label, and select Format Axis from the popup menu list. And the Format Axis dialog will open.

#2 click Alignment menu in the left of Format Axis dialog. And select Rotate all text 90 from the Text direction drop down list box. And click Close button to close the Format Axis dialog.

2. Video: Rotate Axis labels

This video will demonstrate step-by-step instructions on how to rotate axis labels in Excel.

Leave a Reply