XL97: Chart Titles with Multiple Lines Display Only One Line

ID: Q185392

The information in this article applies to:

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:

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.

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          : kbdta
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbbug
Solution Type     : kbpending

Last Reviewed: February 12, 1999