Show All

Hide All

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  , Center   , or Align Right    on the Formatting toolbar.
• To quickly rotate selected text 45 degrees up or down, click Angle Text Upward    or Angle Text Downward   on the Chart toolbar.