Knowledge Base

XL97: Chart Titles with Multiple Lines Display Only One Line

Article ID: 185392

Article Last Modified on 10/19/2000

Microsoft Excel 97 Standard Edition

This article was previously published under Q185392

SYMPTOMS

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.

CAUSE

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

WORKAROUND

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:

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

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

STATUS

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

REFERENCES

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:

charts, formatting

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.

Additional query words: XL97

Keywords: kbbug kbpending KB185392