How to Round Data Labels in an Excel Chart

Charts & pivot tables · Updated November 20, 2026

To round numbers shown on an Excel chart without changing the underlying data, select the chart’s data labels, press Ctrl+1, open Number in the Format Data Labels pane, and set the decimal places or a custom number format. If the labels come from cells as text, round the values in a helper column and use that column for the chart or its labels instead.

This guide is for Excel for Microsoft 365 on Windows. Number formatting changes how numeric labels look; it does not round the values in your worksheet or change calculations that use them. That distinction is useful when you want a cleaner chart but still need the original precision for analysis.

What You’ll Need

  • An Excel workbook with a chart and data labels. If the chart has no labels yet, select it and choose Chart Design > Add Chart Element > Data Labels, then choose a position.
  • Access to the chart’s source data, especially if you plan to use helper values or labels created from cells.
  • Excel for Microsoft 365 desktop for the fullest set of chart-formatting controls. Excel for the web and some Mac versions may show a different pane or fewer options.

Step-by-Step

  1. Select the chart labels. Click the chart once, then click one of its data labels once to select the whole set of labels for that series. A selection outline or handles should appear around the labels. If the chart has multiple series, select the labels belonging to the series you want to change; formatting one series does not necessarily format the others.
  2. Open the formatting pane. Press Ctrl+1 on Windows, or right-click a selected label and choose Format Data Labels. The Format Data Labels pane should open. If only one label is selected, click a label once more only if you intend to format that single point; avoid changing one label accidentally when you want all labels in the series to match.
  3. Find the number controls. In the pane, choose Label Options if needed, then expand Number. The exact arrangement can shift slightly between Excel builds, but the control is in the data-label formatting pane, not the Format Axis pane. If you see axis controls, close that pane and select a data label directly before reopening the formatting options.
  4. Choose a number category. For ordinary numeric values, select Number. Set Decimal places to 0 for whole numbers, 1 for one digit after the decimal point, or another value that suits the chart. For example, changing 18.746 to zero decimal places displays 19, while one decimal place displays 18.7. This is a display change: the worksheet value remains 18.746.
  5. Use a custom format when you want more control. In the Number section, choose Custom if it is available, and enter a format code. Use #,##0 for rounded whole numbers with thousands separators, #,##0.0 for one decimal place, or 0.00 for two decimal places without a thousands separator. The number format controls what is shown, not the precision stored in the source cell.
  6. Check percentage and currency labels carefully. Choose Percentage only when the source values represent fractions, such as 0.25 for 25%. A format such as 0% displays 0.25 as 25%, and 0.256 as 26% when rounded to a whole percent. If your data contains 25 to mean 25%, use a number format that does not multiply the display by 100, such as 0 followed by a percent sign, or keep the existing suitable percentage format and adjust its decimal places. For money, retain the appropriate currency symbol and set the desired decimal places rather than switching to a plain number format unintentionally.
  7. Decide whether to keep the source-linked format. If Linked to source is checked, the chart label may follow the number format of its worksheet cell. To give the chart labels their own format, clear Linked to source if that option appears, then set the category and decimal places in the pane. If you want the chart to follow later changes to the source cells, leave the link enabled and format those cells instead.
  8. Repeat for other series and review the result. Select each additional series’ labels and apply the same settings if the chart contains more than one series. Check small and large values, negative numbers, and any values near a rounding boundary. If the labels now overlap or become hard to distinguish, change their position or reduce the number of labels shown rather than making the text too small.

Excel’s displayed rounding follows its number-format rules; it does not replace the source value with a rounded one. If the chart’s labels are meant to show an actual rounded result that must also be used in later calculations, create rounded values in cells and chart those values instead. With the original values in B2:B10, put a heading such as Rounded in C1 and enter this in C2:

=ROUND(B2,0)

Fill the formula down through C10. For example, if B2 contains 18.746, C2 returns 19. To round to one decimal place, use =ROUND(B2,1); 18.746 returns 18.7. Add the helper column to the chart or use it as the series values. This approach changes what the chart plots, so it can affect the chart’s shape and any conclusions drawn from it; keep the original column if its precision is still important.

If your chart uses labels taken from cells, a different limitation applies: labels imported with Value From Cells are treated as text. Excel cannot apply a numeric number format to text such as 18.746. In that case, either switch to labels that display the chart’s numeric value and format those, or prepare rounded display text in worksheet cells and use those cells for the labels.

Common Mistakes

  • Confusing display rounding with calculation rounding. Setting zero decimal places can make 4.6 look like 5, while formulas elsewhere still use 4.6. Use a ROUND helper column only when the chart should plot rounded values or the rounded numbers must be used in calculations.
  • Formatting the axis instead of the labels. Axis numbers and data labels have separate settings. If the tick marks change but the labels above the columns do not, select a data label and open Format Data Labels rather than formatting the axis.
  • Leaving Linked to source on without realizing it. A source cell’s number format can override or influence what appears on the chart. Either format the source cells, or turn off the link and set the label format directly, depending on whether you want the chart to inherit later worksheet formatting.
  • Applying a percentage format to whole-number percentages. If 25 already means 25%, a standard percentage format can display it as 2500%. Confirm whether the stored value is 25 or 0.25 before choosing Percentage.
  • Expecting numeric formatting to change text labels. A label returned from Value From Cells may look like a number but still be text. Use a rounded numeric helper series or create the label text in the worksheet.
  • Rounding too aggressively. Several distinct values can become identical when displayed as whole numbers. This may hide meaningful differences, so compare the chart with the source data and use enough decimal places to tell important values apart.

Tips

  • Choose precision based on the chart’s purpose. For a high-level comparison, whole numbers may be easier to scan. For scientific, operational, or financial reporting, one or two decimal places may preserve distinctions readers need. Avoid showing more digits than the data supports.
  • Use a consistent format across a series. A column of labels with mixed decimal places can look untidy and make comparisons slower. Apply one format to the whole series unless a specific point needs a deliberate exception.
  • Keep the original data visible and documented. A helper column is clearer when its heading explains that it contains rounded chart values. It also makes it easier to distinguish the displayed or plotted numbers from the precise source measurements.
  • Preview how rounding affects small values. Values below 0.5 display as 0 with a whole-number format, and small percentages can also round to 0%. If zero could be misleading, show an extra decimal place or use a helper label that communicates the value appropriately.
  • On Mac, use the formatting pane or context menu. Select the labels and open Format Data Labels from the context menu or the chart-formatting controls. The pane may be arranged differently from Windows, and keyboard shortcuts can vary by keyboard and Excel release. Excel for the web may expose fewer number-format options; if Number or Custom is missing, open the workbook in the desktop app.

Troubleshooting

The labels did not change. First confirm that the labels, rather than the chart area, axis, or plot area, are selected. Reopen Format Data Labels and check that the Number section is expanded. If Linked to source is enabled, format the corresponding source cells or clear the link and apply a chart-specific format. Repeat the change for each series if necessary.

The Number section is missing or does not affect the labels. Check whether the labels were created with Value From Cells. Text supplied from cells does not receive numeric formatting in the chart pane. Create rounded values or display text in helper cells, then update the label range, or use the chart’s numeric value labels instead. Also check that the selected object is a data label, not an axis label.

Values show too many decimals after changing the setting. Confirm that you selected the correct series and that the decimal-place control is set as intended. A custom format can take precedence over a general category choice, so replace the custom code with a suitable one such as #,##0.0 or choose Number and set the decimals again. If the labels are source-linked, check the number format of the source cells.

Percentages look 100 times too large or too small. Inspect the underlying values in the worksheet. A stored 0.4 conventionally represents 40% under Percentage formatting; a stored 40 may already mean 40 in the dataset. Choose a display format that matches the data’s storage convention and verify the result against a known value.

Rounded labels overlap or hide differences. Try placing labels inside or outside the chart elements, widening the chart, or displaying fewer labels. If rounding makes multiple values identical, restore a decimal place or use a helper series with enough precision. Avoid changing the plotted values solely to make labels fit unless that change is appropriate for the chart’s purpose.

Frequently Asked Questions

Does rounding a chart label change the value in the worksheet?
No. Formatting the label changes its appearance only. The worksheet retains its original number, and formulas that refer to it continue to use that number. A ROUND formula in a helper column creates a separate rounded value.

Can I round labels to the nearest whole number?
Yes. Select the labels, open Format Data Labels, expand Number, choose Number, and set Decimal places to 0. If you need the chart to use rounded values rather than only show rounded labels, use a helper column with a ROUND formula.

Can I show one decimal place but keep the exact source value?
Yes. Set the label’s decimal places to 1. A value such as 6.347 will display as 6.3 while the cell still contains 6.347. The chart’s calculations and source data remain unchanged.

Why does Value From Cells ignore my number format?
Those labels are supplied as text, so Excel displays the text rather than formatting it as a numeric value. Prepare the rounded wording in cells, or switch to numeric data labels and format them in the Number section.

Can I round only one data label?
Yes. Select the series’ labels, then select the individual label you want to change and apply its number format. Be aware that selecting a single point changes only that point; select the whole set again to apply a consistent format to the series.

Will the formatting remain if the chart data changes?
Usually, the chart’s number format remains applied as data updates, but linked source formatting can change when the source cells’ formats change. If the appearance must stay independent, clear Linked to source where available and set the format on the chart labels. Check the chart after replacing or restructuring its data.

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.