How to Add Error Bars in Microsoft Excel

Quick summary

Adding error bars in Excel lets you visually represent data variability or uncertainty directly on a chart. You can insert standard, percentage, or custom error bars in just a few clicks using the Chart Design ribbon.

Steps

1. Select the chart to which you want to add an error bar.
2. Click Add Chart Element on the Excel ribbon.
3. Select Error Bars and choose the type of error bars you prefer.
4. Click on the error bar to select it, then customize it as needed.