Error bars show how much your data could vary. Add them to any Excel chart in under two minutes here’s exactly how.
What Even Are Error Bars?
Picture this. Your colleague shares a chart showing average monthly sales. Looks clean. But you know sales swung wildly some months great, some rough. Error bars show that range visually. Little lines sticking out of each data point, saying “hey, the real number could be a bit higher or lower.”
That’s it. Nothing scary.
My friend Priya data analyst, absolute Excel nerd told me she avoided error bars for two years because she thought they were “advanced.” Then she tried it. Five clicks. Done.
How to Add Error Bars in Excel (Quick Steps)
First, you need a chart. Column chart, bar chart, line chart all work fine.
Here’s the fastest way:
- Click on your chart
- Hit the + icon that pops up on the right side
- Hover over Error Bars
- Click the small arrow that appears next to it
- Pick your type Standard Error, Percentage, or Standard Deviation
That’s genuinely it. Excel draws the bars automatically.
Quick tip if you’re on a Mac, the + button might not show. Go to Chart Design → Add Chart Element → Error Bars instead. Same result, slightly different path.
Which Type Should You Pick?
Here’s the thing most tutorials skip this part.
- Standard Error → Use this when you’re showing data from a sample and want to show how reliable the average is. Good for surveys, experiments.
- Percentage → Excel adds 5% error on each bar by default. Works well for quick presentations where exact values don’t matter much.
- Standard Deviation → Shows how spread out your data is. Great for scientific or academic charts.
- Custom → You control every single bar. Different lengths for different points. Best for real-world data where each value has its own margin.
Not sure? Start with Standard Error. Works for most people most of the time.
Adding Custom Error Bars (Different Length for Each Bar)
This is where it gets a little more useful.
Say you’ve tracked temperatures across five cities. Each city has its own margin of error different data sources, different reliability. Same error bar for all five would be misleading.
Here’s what to do:
- Put your error values in a separate column in your spreadsheet
- Click your chart → + icon → Error Bars → More Options
- In the Format Error Bars pane, select Custom → Specify Value
- Select your error value range for positive, repeat for negative
- Hit OK
Each bar now has its own length. Accurate. Professional. Nah, not hard at all.
Why Your Error Bars Might Not Be Showing
Common panic moment you added them, nothing happened.
Check these fast: Did you click on the actual chart before hitting the + icon? Sometimes Excel needs you to click directly on a data bar first. Also, error bars don’t work on pie charts or 3D charts. Flat charts only. Switch chart type and try again.
FAQ’s
Can I add error bars to just one data series?
Yes. Click on that specific series first (just one bar or line), then add error bars. Excel applies them only to the selected series.
How do I remove error bars in Excel?
Click any error bar in the chart → press Delete. Done.
Do error bars work in older Excel versions?
Yes, but the path is different. Go to Layout tab → Analysis group → Error Bars. Works in Excel 2007, 2010, 2013 and up.