Dividing Chart Legend Text Into Multiple Lines

ID: Q73226

The information in this article applies to:

Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0
Microsoft Excel for OS/2, versions 2.2, 2.21, and 3.0

By default, Excel places the description for each item in a chart legend on a single line. If the legend text contains multiple words, it can occupy much of the chart area. The solution is to break each legend into multiple lines.

Example

Create a chart in Excel with a legend that contains multiple words.

Activate the spreadsheet that contains the chart data.

Select the first cell on the spreadsheet that contains the legend text.

Press the F2 key to edit the line.

Move the cursor to where the legend text should break.

Hold down the ALT key and press ENTER. In Excel 2.x, you need to hold down the ALT key and type 013, which is the Carriage Return character.

The text will break at that point. Repeat these steps as needed until all the legend texts are divided. Activate the chart to view the new legend.

REFERENCES

"Microsoft Excel User's Guide." Version 3.0, chapter 11.

"Microsoft Excel Reference Guide." Version 2.x, pages 33-55.

Additional query words: 2.00 2.0 2.01 2.1 2.10 2.2 2.21 2.20 3.0 wrap text


Keywords          : 
Version           : 
Platform          : 
Issue type        :

Last Reviewed: March 21, 1999