How to do standard error bars on excel charts

Written by shreya mehta
  • Share
  • Tweet
  • Share
  • Email

Error bars are expressed as the percentage of possible error amounts for each data point in a two-dimensional chart. They help indicate whether there are significant differences between two variables that are being compared. Standard error bars represent the standard deviation of the mean. Calculating standard errors and drawing the bars manually can be tedious. Microsoft Excel makes this task easier with it Standard Error bar feature. Learn how to add and customise standard error bars in charts using Microsoft Excel.

Skill level:

Other People Are Reading

Things you need

  • Microsoft Excel 2007

Show MoreHide


  1. 1

    Open a new workbook in Microsoft Excel. Enter data points in cells down two columns. For example, if we want to plot the number of students that earned a certain average exam grade, we would list the number of students down column A and the average grade in column B.

  2. 2

    Highlight the data in both columns. Go to the "Insert" tab and choose a chart type. For example, we can choose a scatter chart to plot the data.

  3. 3

    Click on a data point to select all of the data points in the chart, or click twice on a data point to only select that data point. You can have standard error bars for one data point or all of the data points.

  4. 4

    Go to the "Layout" tab under Chart Tools and click on "Error Bars." Select "Error Bars with Standard Error."

  5. 5

    Click on the "Error Bars" menu and select "More Error Bar Options." You can change the direction of the error bars, the end style, and the error amount. The line colour, style and shadow can also be customised.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.