Inserting line breaks in labels
Variable labels and value labels automatically wrap to multiple lines in pivot tables and charts if the cell or area isn't wide enough to display the entire label on one line, and you can edit results to insert manual line breaks if you want the label to wrap at a different point. You can also create variable labels and value labels that will always wrap at specified points and be displayed on multiple lines.
- For variable labels, select the Label cell for the variable in Variable View in the Data Editor.
- For value labels, select the Values cell for the variable in Variable View in the Data Editor, click the button in the cell, and select the label that you want to modify in the Value Labels dialog box.
- At the place in the label where you want the label to wrap, type \n.
The \n is not displayed in pivot tables or charts; it is interpreted as a line break character.