Excel Tip of the Day
Rotate labels to improve chart readability (Excel 97/2000/2001/2002)
There may be times when space limitations prevent Excel from displaying all of the category labels in a chart. Excel will try to compensate by displaying labels at an angle, and will adjust the angle as you resize the chart. However, there may be times when you want to personally determine how the labels appear. Fortunately, it's easy to manually set the rotation angle. Note that this technique also works for value axis and data series labels.
First, double-click on the labels you want to change. When the appropriate Format dialog box appears, click on the Alignment tab. You can set a specific angle using the Degrees text box or by clicking in the Orientation preview box. Either of these actions will rotate the label controls; however, the text remains oriented horizontally within the control. If you'd rather display the label text vertically, click the vertical preview box in the Orientation panel.
(Content provided by Element K Journals)
(Note: Your browser is set to refuse cookies. As a result, you may frequently see previously-viewed tips)
Print
CloseCopyright © 2001 - 2025 MJ Technologies, LLC. All rights reserved.