How to Rotate Text in an Excel Chart (2 Methods)

Scenario

Here, we have an Excel chart of sales quantity containing months on the X-axis and the value of sales quantity on the Y-axis. Now we want to rotate the text.Rotate Text in an Excel Chart


Method 1 – Changing the Orientation of Text in an Excel Chart

  • Select the text on the X-axis.

Changing the Orientation of Text in Excel Chart

  • Go to the Home tab and click on an option (such as Angle Counterclockwise) to rotate the X-axis text counterclockwise.

click on Counterclockwise to Rotate Text in an Excel Chart

Result:

The output can be seen in the below image:

get the Rotate Text in an Excel Chart

Read More: How to Add Subscript in Excel Graph


Method 2 – Using Format Axis to Rotate Text in an Excel Chart

In this method, there are two ways to rotate text using Format Axis:

2.1 Selecting Text Options

  • Select the text on the X-axis.
  • Right-click and choose Format Axis.

Selecting Text Options to Rotate Text in Excel Chart

  • In the Format Axis dialog box, select Text options.
  • Click on the Text Box option.
  • Choose a text direction (e.g., Rotate all text 900) to rotate the X-axis text clockwise.

rotate all text by 90 degree

The desired output can be seen in the image below:

get the Rotate Text in an Excel Chart

Rotate by Selecting a Custom Angle

  • Right-click the X-axis text and select Format Axis.

Rotate by selecting Custom Angle

  • Navigate to Format Axis, select Text Options and click on Text Box.
  • Enter a custom angle (e.g., 300) to achieve the desired rotation.

Result:

The desired output can be seen in the image below:

show the Rotate Text in an Excel Chart


2.2 Selecting Axis Options

  • Select the X-axis text and right-click to access Format Axis.

By Selecting Axis Options Rotate Text in Excel Chart

  • In the Format Axis dialog, choose Axis options.
  • Under Alignment, select a text direction (e.g., Rotate all text 900) for clockwise rotation.

You will get the following output.

show the output

Rotate by Selecting a Custom Angle

  • Right-click the X-axis text and select Format Axis.

Rotate by Selecting a Custom Angle

  • Go to Format Axis, select Axis Options and click on Text Box.
  • Enter a custom angle (e.g., 450) to achieve the desired rotation.

Result:

The desired output can be seen in the image below:

get the Rotate Text in an Excel Chart

Read More: How to Change Text Direction in Excel Chart 


Download Practice Workbook

You can download the practice workbook from here:


Related Articles


<< Go Back to Formatting Chart in Excel | Excel Charts | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Saquib Ahmad Shuvo
Saquib Ahmad Shuvo

Saquib Ahmad Bhuiyan, holding a BSc degree in Naval Architecture & Marine Engineering from Bangladesh University of Engineering and Technology, skillfully integrates engineering expertise with a passion for Excel. He provides solutions to complex issues as an Excel & VBA Content Developer for ExcelDemy Forum. He demonstrates an enthusiastic mindset and adeptness in managing critical situations with finesse, showcasing his commitment to excellence. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel, Rhinoceros,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo