Add error bars to a data series


Select a display option.

Error amount

Select one from the following options —Fixed value, Percentage, Standard deviation(s), or Standard error.

Access and Excel uses specific equations to calculate the Standard deviation(s) and Standard error error amounts. For more information, see Equations for calculating the error amount.


  • If you change the datasheet values associated with the data points in the series, the error bars are adjusted to reflect your changes.

  • The direction of the error bars depends on the type of chart you’re using. Scatter charts can show both horizontal and vertical error bars. You can remove either of these error bars by selecting them, and then pressing Delete.

See Also

Error bars in charts

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.