Are you looking to rotate the chart data labels in Excel? In this blog post, you will explore 2 methods to rotate data labels in Excel.
Rotating data labels makes the chart and its information easier to read and understand. You can rotate particular data labels to highlight significant data points. It will be very helpful if you are dealing with lengthy text. Excel graphs with rotated data and axis labels give their contents a more present appearance.
How to Rotate Data Labels using Format Data Labels
First, you need to add data labels to the chart. Just right-click on the bar and Click Add data labels. Once added the data labels, Sometime you can see the data labels are overlapped in the graph.
Steps to rotate the data labels in excel.
- Right mouse click on the data labels and select Format Data Labels, to open Format Data Labels pane
- Click Text Options in the Format Data Labels
- Click the last option Textbox.
- Choose Rotate all text 270° in the Text direction drop down list.
The shortcut key Ctrl + 1 to directly open the Format Data Labels box.
How to Rotate Data Labels using Orientation Alignment
By using this method, you can select any text or text boxes in Excel and apply the orientation alignment.
Steps to Rotate data labels in Excel using the Orientation Alignment
- Click the chart data labels
- Select the Orientation button in the alignment groups in the Home tab.
- Choose the option Rotate Text UP
You can use this method to rotate text boxes, graph axis, and Titles.
Conclusion
Rotating text is a type of data formatting. It allows you to highlight the important KPI in Excel. Sometime developers used for lengthy text to accommodate in the container.
I hope this blog post has helped you to rotate text in Excel. If you have any questions or feedback, please leave a comment below.
