How to Wrap Data Labels in an Excel Chart

Charts & pivot tables · Updated November 20, 2026

To wrap data labels in an Excel chart, put a line break in the text you want displayed, then use that text as the chart label. In Excel for Microsoft 365 on Windows, the most dependable method is to create or edit label text in worksheet cells and choose those cells with Format Data Labels > Label Options > Value From Cells. Excel does not provide a universal Wrap Text switch for chart data labels, so a deliberate line break is usually the key.

This is useful when labels are long, crowded, or need to show two pieces of information on separate lines. Before starting, decide which labels should break and whether you can use custom text from cells. Keep a copy of the workbook if the chart is important, especially before changing a large set of labels.

What You’ll Need

  • An Excel workbook containing a chart with data labels. If labels are not showing yet, you can add them during the steps.
  • Worksheet cells containing the text you want displayed, or a helper column where you can prepare that text. A line break can be entered directly into a cell.
  • Excel for Microsoft 365 on Windows for the menu paths below. Excel for Mac has comparable chart-label options, though ribbon and keyboard details can differ. Excel for the web may have fewer chart-formatting controls; use the desktop app if you cannot find Value From Cells.

Step-by-Step

  1. Check what the labels currently show. Select the chart and inspect its labels. If they are missing, select the chart, then choose Chart Design > Add Chart Element > Data Labels and select a suitable position, such as Outside End or Center. You can also use the chart’s plus button, if it appears, and turn on Data Labels. If you only need to wrap existing category names or custom text, continue to the next step. For a chart with multiple series, identify which series’ labels you want to change; each series may need its own label range.
  2. Prepare the label text in worksheet cells. Make a helper column next to the chart’s source data, or use an existing column if it already contains the exact wording you want. Put each complete label in one cell, with one cell for each plotted point. To create a line break while editing a cell in Windows Excel, place the cursor where the second line should begin and press Alt+Enter. For example, a label could show a product name on the first line and its region on the second. On Excel for Mac, the in-cell line-break shortcut is commonly Control+Option+Return; keyboard behavior can vary by version and keyboard layout. You can also edit the text in the formula bar and insert the break with the appropriate shortcut.
  3. Make sure the helper cells contain only the intended labels. Match the order of the cells to the order of the chart points. If the chart plots rows 2 through 8, select the corresponding seven label cells—not a heading or a total. The labels can be entered manually or returned by formulas, but the displayed text must contain an actual line break for the chart to show two lines. Applying Home > Wrap Text to a worksheet cell by itself does not necessarily add a break to the text that the chart receives. If a label is too long, shorten it or insert a break at a sensible point rather than relying on the cell’s visual wrapping.
  4. Select the chart labels you want to format. Click one data label once to select the entire set for that series. In some chart types, clicking a second time selects just one point’s label. For a consistent set of labels, use the first click and leave the whole set selected. Right-click the selection and choose Format Data Labels to open the formatting pane. If you accidentally select the chart area or a single point, click away and try again. You can confirm the selection by checking the pane heading and whether the formatting affects all labels in that series.
  5. Connect the labels to your worksheet cells. In the Format Data Labels pane, open Label Options. Under Label Contains, select Value From Cells. In the range-selection box, select the helper cells that contain your prepared labels, then confirm the range. If a dialog appears, select OK. The chart should now display the text from those cells, including line breaks. If you want only the custom text, clear options such as Value, Category Name, or Series Name that would add extra information. Keep any option you deliberately need—for example, keep Value if you want the number displayed alongside your custom label.
  6. Adjust the label position and chart space. If the new two-line labels collide with one another, select a position that gives them more room using Chart Design > Add Chart Element > Data Labels, or use the Label Position options in the formatting pane when available for that chart type. Enlarge the chart or plot area, reduce the font size slightly, or shorten the wording. You can sometimes drag an individual label to a clearer position, but dragging is a manual adjustment and may need repeating if the data or chart size changes. Check that labels do not cover important bars, points, or other labels.
  7. Review the result at the size people will see it. Click outside the chart, then inspect the labels at normal worksheet zoom and, if relevant, in print preview or the presentation where the chart will appear. Check several points, including the longest label and labels near the chart edges. If the chart is linked to changing data, edit a source label to confirm that the chart updates as expected. Save the workbook after confirming the words, line breaks, and label positions are correct.

Common Mistakes

Expecting automatic text wrapping. A chart label is not a worksheet cell, and the worksheet’s Wrap Text button is not a general chart-label wrapping control. Add an actual line break to the text supplied to the label instead.

Selecting the wrong cell range. A heading, blank row, or extra total can misalign the labels with chart points. Select only the cells that correspond to the points in that series, in the same order. For multiple series, do not assume one range will label every series correctly; set up and check each series separately.

Leaving other label components turned on unintentionally. If Value, Category Name, or Series Name remains selected, Excel may show that information in addition to the custom text. This can make a correctly wrapped label look duplicated or crowded. Review the Label Contains checkboxes and turn off anything you do not want.

Adding a break in the wrong place. A break after a space or punctuation mark is usually easier to read than splitting a word. Very short first lines can also make a chart look uneven. Preview the complete set rather than judging only the first label.

Tips

Use helper cells when chart labels need a consistent, maintainable layout. Keeping the source values separate from the display text makes it easier to revise wording without changing the data used to build the chart. Name the helper-column heading clearly, such as “Chart label,” so another person can tell why it is there. If the labels depend on data that changes regularly, keep the helper cells aligned with the chart’s source rows and include newly added points in the label range.

Break labels at a natural boundary: between a name and a location, before a date, or between a category and a short qualifier. Two balanced lines are generally easier to scan than one very long line followed by a single word. For numeric charts, consider whether the number should remain as a separate chart value or be included in the custom label; showing the same value twice can be confusing.

Use the chart’s available space as part of the solution. A wider chart can help labels placed beside bars, while a taller chart may help labels above columns. For a pie or doughnut chart, crowded labels may be clearer in a legend or a separate table rather than forced into a small area. Keep the font readable, and check the chart against a light and dark background if it will be reused in different documents.

Remember that label layout can change when the chart is resized, the font changes, or the data changes. After making any of those edits, scan for overlap and clipped text. If you need a stable layout for a report, consider setting the chart to a sensible final size before making fine adjustments to individual label positions.

Troubleshooting

Value From Cells is missing. First make sure you selected data labels rather than the chart area, axis labels, or a legend. Right-click a data label and choose Format Data Labels, then look under Label Options. Some chart types, older Excel releases, and Excel for the web may offer different controls. Open the workbook in the current desktop version of Excel for Microsoft 365 if the option is unavailable in your app.

The chart shows the text but not a second line. Confirm that the source cell contains an in-cell line break, not merely a narrow column that makes worksheet text appear on two lines. Re-edit the cell and insert the break with Alt+Enter on Windows. Then check that Value From Cells points to that exact cell. A cell that contains a formula can still supply chart text, but its displayed result must include the line break.

The label text is repeated or includes an unwanted number. Reopen Format Data Labels and inspect Label Contains. Clear any unwanted Value, Category Name, or Series Name option. If the text is still duplicated, verify that the selected range does not contain the same phrase as another enabled label component.

Labels are in the wrong order or attached to the wrong points. Check the range boundaries and the order of the chart’s source data. Select one label cell per point, in the same sequence the points appear in the series. If the chart has several series, select each series’ labels separately and assign the matching cells for that series.

Text is cut off or labels overlap. Increase chart dimensions, try a different label position, reduce wording, or use a slightly smaller font. You may also move a label manually where that improves clarity. If the chart is too dense for readable labels, show fewer labels or provide details in a legend or table; wrapping cannot create more space in a fixed-size chart.

Frequently Asked Questions

Can I turn on Wrap Text for Excel chart data labels?
No general Wrap Text control applies to chart data labels in the same way it applies to worksheet cells. Put a line break in the label text and use that text for the chart label.

Will Alt+Enter in a worksheet cell wrap the chart label?
It inserts a line break in the cell’s text. When the chart uses that cell through Value From Cells, the break can appear in the label. Simply turning on worksheet Wrap Text is not the same as inserting a line break.

Can I wrap labels that show values rather than text?
Use custom label text from cells if you need a specific two-line arrangement. You can prepare a helper cell for each point and select those cells with Value From Cells. Make sure any separate value option is disabled if you do not want the number repeated.

Do I need to change every data label one at a time?
Usually not. Assigning a matching range through Value From Cells applies the custom text to the selected series’ labels. You may still need to adjust an individual label’s position if one point is unusually crowded.

Will the line breaks remain if the chart updates?
They remain as long as the chart continues to use the same label cells and those cells still contain the breaks. If you add data points or change the source range, update the label range too and check that the order still matches.

Can I do this in Excel for the web?
You may be able to edit the worksheet text and some chart settings in the web app, but chart-label options can vary. If you cannot find Value From Cells or cannot position labels as needed, open the workbook in Excel for Microsoft 365 on Windows or Mac.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.