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.

Error bars in charts

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!