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.
- 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.
- On the Format menu, click Selected Chart Title or Selected Axis Title.
- 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.
- 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.