Excel Chart Error Bars: How to Add and Customize Them

Excel chart error bars show the amount of uncertainty, variation, or measurement range associated with plotted values. In Microsoft Excel for Microsoft 365 on Windows, select the chart and use Chart Design > Add Chart Element > Error Bars to add a built-in option or configure custom values.

What Excel chart error bars show

An error bar is a line drawn from a chart point or column to mark a range above and below that value. A chart of average test scores, for example, might show each average with bars representing the spread of individual results. A chart of measured temperatures might instead show the instrument’s expected measurement uncertainty. In both cases, the bars add information that the central value alone cannot convey.

Error bars do not have one universal meaning. Depending on the option selected, they can represent a fixed amount, a percentage, standard deviation, standard error, or values supplied from worksheet cells. The same visual mark can therefore communicate very different things. A reader should be able to tell what the bars mean from a chart caption, axis note, or nearby explanation.

They also do not automatically prove that a difference between two plotted values is statistically significant. Whether intervals overlap is not, by itself, a complete statistical test. Choose the interval that matches the question and explain how it was calculated.

How to add error bars in Excel

For a standard two-dimensional chart, first select the chart. On the ribbon, open Chart Design > Add Chart Element > Error Bars, then choose Standard Error, Percentage, or Standard Deviation. Choose More Error Bar Options to open the Format Error Bars pane and adjust settings. You can also select the chart and use the Chart Elements button beside it, if that button is available in your Excel window.

Click the chart, then click the data series whose error bars you want to change. If the chart has multiple series, check that the correct series is selected.
Choose Chart Design > Add Chart Element > Error Bars, then select an option or open More Error Bar Options.
In the Format Error Bars pane, set the direction to Both, Plus, or Minus, and choose whether the ends have caps.
Under Error Amount, select the calculation you need. For worksheet-based ranges, choose Custom, select Specify Value, and enter or select the positive and negative cell ranges.

You can also right-click an existing error bar and choose Format Error Bars. To remove error bars, select them and press Delete. If clicking selects the whole series instead of the bars, click again carefully or use the Current Selection controls on the Format tab to select the error bars.

What the built-in error bar options mean

Excel offers several quick choices, but each answers a different question. A default selection is not a substitute for deciding what the data should communicate.

Standard Error displays an estimate of the standard error for the plotted series. It relates to the precision of a mean, not the spread of individual observations.
Standard Deviation displays a standard-deviation-based range for the plotted series. Standard deviation describes how dispersed observations are.
Percentage uses a specified percentage of each plotted value. It is a proportional range, not a statistical confidence interval.
Fixed Value applies the same absolute amount to the plotted points. It can suit a known instrument tolerance or a consistent allowed range.
Custom uses positive and negative amounts from worksheet cells, allowing different ranges for different points and asymmetric bars.

Excel’s built-in statistical choices work from the values in the chart series. They do not automatically identify the separate replicate observations behind each category mean or calculate a confidence interval for each group using its own sample size. If each category has different raw data, calculate the appropriate range for each category and use Custom values.

How to create custom error bars

Custom bars are useful when each plotted point has its own uncertainty or when the upper and lower ranges differ. Keep the chart values and error amounts in aligned rows: the first error amount should correspond to the first plotted point, the second to the second point, and so on. In the Format Error Bars pane, choose Custom > Specify Value. In the dialog, specify a cell range for Positive Error Value and a range for Negative Error Value. The ranges should contain the intended nonnegative distances, not the final upper and lower chart coordinates.

For example, if a chart point is 12 and its lower limit is 10 while its upper limit is 15, the negative error amount is 2 and the positive amount is 3. Excel draws from the point to those limits. Put the two amounts in separate worksheet columns and select those columns in the custom-value dialog. Using the same range for both fields creates symmetrical bars; different ranges create asymmetrical bars.

When the underlying data changes, formulas in the custom-range cells can update the bars automatically. This is often more transparent than typing values into the chart, since the calculations remain visible in the workbook. Check that the ranges cover the plotted points in the same order and contain no accidental headers or unrelated cells.

Example: standard error for category averages

Suppose rows 2 through 4 contain three categories, with replicate measurements in columns B through D. The first category has measurements 10, 12, and 14. Its average is 12, its sample standard deviation is 2, and its standard error is about 1.155. The standard error is the sample standard deviation divided by the square root of the number of observations.

With the first category’s replicate measurements in B2:D2, enter this in E2 to calculate the mean; it returns 12 for the example values:

=AVERAGE(B2:D2)

With those same measurements in B2:D2, enter this in F2 to calculate the sample standard deviation; it returns 2:

=STDEV.S(B2:D2)

With the sample standard deviation in F2 and the three measurements in B2:D2, enter this in G2 to calculate the standard error; it returns approximately 1.1547:

=F2/SQRT(COUNT(B2:D2))

Fill the calculations down for the other categories, chart the means in column E, and use the standard-error amounts in column G as both the positive and negative custom ranges if symmetrical bars are intended. This example describes standard errors, not confidence intervals. A confidence interval needs an appropriate multiplier and method for the study; do not label standard-error bars as confidence intervals.

Choosing a meaningful error range

Start with what each point represents and what readers need to know. If points are individual observations and you want to show their spread, a standard-deviation range may be relevant. If points are sample means and you want to show their estimated precision, standard error or a suitable confidence interval may be more appropriate. If the range comes from a device specification, use that documented measurement tolerance. For percentage-based variation, confirm that a proportional range is justified rather than merely convenient.

Also consider sample size and distribution. Standard error generally decreases as sample size increases, even if the underlying variability is unchanged. Standard deviation describes variability in the observations and does not shrink just because more observations were collected. For small samples or data that do not meet the assumptions of a simple interval, a confidence interval may require a method beyond the chart’s built-in choices.

State the definition in the chart title, caption, or a note, such as “mean ± 1 standard error” or “measurement tolerance ± 0.5 units.” If the positive and negative amounts differ, explain why. Clear labeling helps prevent readers from treating every error bar as the same kind of uncertainty.

Which charts support error bars?

Error bars are commonly available for supported two-dimensional statistical and measurement charts, including column, bar, line, scatter, and bubble charts. A scatter chart can show horizontal X error bars, vertical Y error bars, or both, which is useful when both measured variables have uncertainty. For a column or line chart, the familiar bars usually indicate vertical variation in the plotted values.

Options vary with chart type. Excel does not offer error bars for every chart, and three-dimensional charts or charts such as pie charts are not suitable for the usual point-by-point error-bar treatment. If the Error Bars command is unavailable, check the chart type and whether a data series is selected. A two-dimensional scatter chart is a useful alternative when the data need both X and Y ranges.

Common problems and fixes

The bars are missing or the command is unavailable: Select a supported two-dimensional chart and a data series. Confirm that the series contains numeric values.
Only one series has bars: Error bars are associated with a selected series. Select another series and add or format its bars separately.
The custom bars look wildly wrong: Check whether you supplied error distances rather than upper and lower endpoint values. Also verify that the selected ranges align with the points and exclude headings.
The range appears on the wrong points: Reorder or correct the custom cells so their sequence matches the chart’s plotted order. Sorting the chart data without updating the custom ranges can cause mismatches.
The bars are hard to see: In the Format Error Bars pane, review direction and end style, then adjust line color or width through the formatting controls. Avoid styling that makes the range look like another data series.

If custom values seem not to update after editing cells, reopen Specify Value and check the references. If the chart is based on a filtered or changing data range, confirm that both the plotted series and custom ranges still refer to the intended observations.

Frequently Asked Questions

How do I add error bars to a chart in Excel?
Select the chart, then choose Chart Design > Add Chart Element > Error Bars. Pick a built-in option or choose More Error Bar Options to set custom values in the Format Error Bars pane.

How do I add different error bars to each point?
Place the positive and negative error distances in worksheet ranges aligned to the plotted points. In Format Error Bars, choose Custom > Specify Value and select the corresponding ranges.

Are Excel standard error bars the same as confidence intervals?
No. A standard-error bar shows a standard error amount, while a confidence interval uses a confidence level and an appropriate statistical multiplier or method. Label the measure actually shown.

Can I show error bars in both directions on a scatter chart?
Yes. Scatter charts can support X and Y error bars. Select the relevant horizontal or vertical error bars in the formatting pane and set their values separately as needed.

Why are my Excel error bars the same for every point?
A fixed value gives each point the same absolute distance, and a percentage gives a proportional distance. Use Custom values if every point needs its own distinct range.

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.