To rotate X-Axis Labels in a Chart, please follow the steps below: Step 1: Right-click X-Axis, then click "Format Axis" in the dialog box; Step 2: In the "Format Axis" window, select "Rotate all text
270" in the Text direction section; Step 3: The following is the chart after rotating. Step 4: You can also custom to any other angle in the Alignment section. Step 5: Here is the chart after rotating 20 degrees. Download Example 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. 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. # 2 click the Size & Properties button in the Format Axis pane. #3 click Text direction list box, and choose Vertical from the drop down list box. Then close the Format Axis pane. #4 the X Axis text has been rotated from horizontal to vertical. 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.
Sometimes, the axis labels in chart are so long that the labels are huddled together as shown as below screenshot. If you do not want to resize the chart size to meet the labels, you can rotate the axis labels to show the labels clearly in Excel. Rotate axis labels in chart Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier... Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
|