XL97: Chart Titles with Multiple Lines Display Only One Line

In Microsoft Excel, when you create a chart and add either a chart title or an axis title that contains multiple lines of text, only one line will appear.

This problem may occur when you rotate the text in the titles on a chart.

To work around this problem, do not rotate the chart titles when they contain multiple lines. To change the format of the title so it is not rotated, follow these steps:

1. Select the title.
2. On the Format menu, click Selected Chart Title or Selected Axis Title, depending on the type of title selected.
3. Click the Alignment tab.
4. Under Orientation, set Degrees to 0.
5. Click OK.

The title will no longer be rotated, but you will be able to view multiple lines of text.

Microsoft has confirmed this to be a problem in Microsoft Excel 97.

For more information about formatting charts, click Contents And Index on the Help menu, click the Index tab in Microsoft Excel Help, type the following text: and then double-click the selected text to go to the "About formatting charts" topic. If you are unable to find the information you need, ask the Office Assistant.