Align text in chart titles and text boxes

To avoid spacing problems with titles (titles in charts: Descriptive text that is automatically aligned to an axis or centered at the top of a chart.) in a chart, you can change the way that titles are aligned, or you can rotate them.

  1. On a chart sheet (chart sheet: A sheet in a workbook that contains only a chart. A chart sheet is beneficial when you want to view a chart or a PivotChart report separately from worksheet data or a PivotTable report.) or in an embedded chart (embedded chart: A chart that is placed on a worksheet rather than on a separate chart sheet. Embedded charts are beneficial when you want to view or print a chart or a PivotChart report with its source data or other information in a worksheet.), click the chart or axis title that you want to align or rotate.
  2. On the Format menu, click Selected Chart Title or Selected Axis Title.
  3. On the Alignment tab, do one of the following:
    • To align text, under Text Alignment, select the options that you want in the Horizontal and Vertical boxes.
    • To rotate text, click the position that you want in the Orientation box, or specify the angle that you want in the Degrees box.
    • To change the direction of the text, under Right-to-left, click the direction that you want in the Text direction box.

 Note   The Alignment tab is only available when you select a title, as instructed in step 1 of this procedure.

Tips

  • To quickly change the horizontal alignment of selected chart or axis titles, click Align Left Button image , Center  Button image  , or Align Right  Button image  on the Formatting toolbar.
  • To quickly rotate selected text 45 degrees up or down, click Angle Text Upward  Button image  or Angle Text Downward  Button image  on the Chart toolbar.
 
 
Applies to:
Excel 2003