How to Change Text Direction in Excel Chart (3 Easy Methods)

While working in Microsoft Excel with the sales-related worksheets, sometimes we need to change text direction in an Excel chart. The chart shows you a trend in the share of total sales that they contribute, NOT a trend in their absolute value. Changing text direction in an Excel chart is an easy task. This is a time-saving task also. Today, in this article, we’ll learn three quick and suitable ways to change text direction in Excel chart effectively with appropriate illustrations.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


3 Suitable Ways to Change Text Direction in Excel Chart

Here, we have an Excel chart of sales quantity containing several quarters on the X-axis and the value of sales value on the Y-axis. Now we want to swap the text direction in the Excel chart using the Orientation command, Horizontal, and Vertical command. Here’s an overview of the dataset for our today’s task.

change text direction in excel chart


1. Use Orientation Command to Change Text Direction

In this method, we will apply the Orientation command to change the text direction in an Excel chart. This is an easy and time-saving task also. To do that, firstly, we will create an Excel chart. Let’s follow the instructions below to swap the text direction in an Excel chart!

Step 1:

  • First of all, select the range of data to draw a chart. From our dataset, we select B4 to E15 for the convenience of our work. After selecting the data range, from your Insert ribbon, go to,

Insert → Charts → 3-D Column

Use Orientation Command to Change Text Direction in Excel Chart

  • As a result, you will be able to create a 3-D column chart which has been given in the below screenshot.

Step 2:

  • Now, we will change the text direction of that chart. To do that, firstly, select the text from the chart. Secondly, from your Home tab, go to,

Home → Alignment → Orientation → Angle Clockwise

Use Orientation Command to Change Text Direction in Excel Chart

  • Hence, you will be able to change the text direction Angle Clockwise which has been given in the below screenshot.


2. Apply Horizontal Command to Change Text Direction

Now, we will apply the Horizontal command to change text direction. Let’s follow the instructions below to change the text direction horizontally!

Steps:

  • Firstly, select the text on the X-axis. Then right-click and select Format Axis.

Apply Horizontal Command to Change Text Direction in Excel Chart

  • As a result, the Format Axis dialogue box appears, and you have to select Text options.
  • After that, select the Text Box.
  • Then select Horizontal from the Text direction drop-down box.

  • Hence, you will be able to change the text direction horizontally which has been given in the below screenshot.

Apply Horizontal Command to Change Text Direction in Excel Chart


3. Perform Vertical Command to Change Text Direction

Last but not the least, we will apply the Vertical command to change text direction. Let’s follow the instructions below to change the text direction vertically!

Steps:

  • Firstly, select the text on the X-axis. Then right-click and select Format Axis.

Perform Vertical Command to Change Text Direction in Excel Chart

  • As a result, the Format Axis dialogue box appears, and you have to select Text options.
  • After that, select the Text Box.
  • Then select Rotate all text 900 from the Text direction drop-down box.

Perform Vertical Command to Change Text Direction in Excel Chart


Things to Remember

👉 #N/A! error arises when the formula or a function in the formula fails to find the referenced data.

👉 #DIV/0! error happens when a value is divided by zero(0) or the cell reference is blank.


Conclusion

I hope all of the suitable steps mentioned above to change the text direction in the chart will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.

Md. Abdur Rahim Rasel

Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo