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.

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:

#1 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

# 2 click the Size & Properties button in the Format Axis pane.

rotate axis labels2

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

rotate axis labels3

#4 the X Axis text has been rotated from horizontal to vertical.

rotate axis labels4

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.

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar