How to Add Standard Deviation Bars to Bar Graph in Excel

Adding standard deviation bars to your bar graph in Excel is a powerful way to show not just the average value, but also the amount of variability within each data category. This extra layer of context transforms a simple chart into a much more insightful story. This tutorial will walk you through exactly how to calculate standard deviation and add it to your Excel graphs, step-by-step.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Are Standard Deviation Bars and Why Use Them?

In simple terms, standard deviation is a number that tells you how spread out your data points are from the average (or mean). A small standard deviation means your data is tightly clustered around the average. A large standard deviation means the data is widely dispersed.

When you add this measurement to a bar graph in the form of "error bars," you provide immediate visual context. Instead of just seeing that marketing campaign A had a higher average sign-up rate than campaign B, you can also see the consistency of those sign-ups. Did campaign A perform consistently well every day (low standard deviation), while campaign B had huge spikes and drops (high standard deviation)?

These bars help your audience understand:

• Data Consistency: Short bars indicate that the data points for that category are very close to the average, suggesting high predictability and low variance.
• Data Variability: Long bars show that the data is spread out over a wider range. The average value, in this case, might be less representative of any single data point.
• Significance of Differences: When comparing two bars, if their standard deviation bars overlap significantly, the difference between their averages may not be statistically meaningful. If they don't overlap at all, it's a strong indicator of a real difference in performance.

Ultimately, adding standard deviation gives you a more honest and complete picture of what your data is really telling you.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Get Your Data Ready for Analysis

Before we can make a chart, we need to organize our data and calculate the two key metrics Excel needs: the average and the standard deviation.

Let's use a practical example. Imagine a company has tracked the monthly unit sales for three new products - the Lumina, the Solara, and the Apex - over the first quarter.

Here’s the raw data in an Excel sheet: [Insert data here]

To prepare this for graphing, we need to create a small summary table. This table will hold the average and standard deviation of sales for each product.

Calculating the Average

The average shows the central tendency of your data for each category. In Excel, this is done with the AVERAGE function.

In our example, we can calculate the average for the Lumina by typing this formula into a new cell: =AVERAGE(B2:B4)

Do the same for the other products:

• Solara: =AVERAGE(C2:C4)
• Apex: =AVERAGE(D2:D4)

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Calculating the Standard Deviation

Next, we’ll calculate the standard deviation to measure the sales variability for each product. The most common formula for this in Excel, when you're working with a sample of data (like sales for a single quarter), is STDEV.S.

For the Lumina, the formula would be: =STDEV.S(B2:B4)

And for the other products:

• Solara: =STDEV.S(C2:C4)
• Apex: =STDEV.S(D2:D4)

With these calculations, your new summary table should look something like this. This is the table we'll use to create our graph.

Notice the Apex has a much higher standard deviation. This is because its sales were all over the place (187, 85, and 121), whereas sales for the Lumina and Solara were more consistent month-to-month.

Step 2: Create a Basic Bar Graph (Column Chart)

With the summary data ready, creating the initial graph is simple. You only want to plot the averages for now, the standard deviation comes in later.

1. Select Your Data: Highlight the cells containing the product names and their corresponding average sales. In our example table, that would be cells F1 through G4. Be sure not to include the standard deviation column in this initial selection.
2. Insert Chart: Navigate to the Insert tab on Excel’s top ribbon. In the Charts section, click on the icon for "Insert Column or Bar Chart."
3. Choose Your Chart Type: A dropdown menu will appear. Select the "2-D Clustered Column" chart, which is a standard choice for comparing categories.

Excel will instantly generate a bar graph showing the average sales for each product. Now we're ready to add the crucial layer of variability.

Step 3: Add Standard Deviation Error Bars to the Graph

Here's where we add our calculated standard deviation values to the chart. Excel has a built-in feature for this, but it requires a few specific clicks to link it to your custom standard deviation values.

1. Add Chart Element: Click anywhere on your chart to select it. Three icons will appear on the top-right corner. Click the plus sign (+), which is the Chart Elements button.
2. Open More Error Bar Options: In the 'Chart Elements' list that pops up, hover your cursor over Error Bars, click the small arrow that appears to the right, and then select More Options… from the sub-menu. This will open up a formatting pane on the right-hand side of your Excel window.
3. Set Custom Error Amount: In the Format Error Bars pane, ensure the Vertical Error Bar section is active. Scroll down to the Error Amount section at the bottom. The default will be set to "Standard Error" or "Fixed Value." Change this by selecting the circle next to Custom.
4. Specify Your Values: Clicking "Custom" will activate a button below it called Specify Value. Click this button to open a small dialog box labeled "Custom Error Bars." This is where you will tell Excel which cells contain your standard deviation calculations.
5. Link Your Standard Deviation Data:
6. Confirm and Apply: After selecting your data range for both fields, click OK.

Your chart should now update, displaying error bars on each of your columns that precisely match the standard deviation values you calculated.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 4: Interpreting Your New Graph

Looking at the final chart, we can now draw much richer conclusions:

• The Lumina and Solara have relatively short error bars. This tells us their sales were consistent throughout the quarter. You can be fairly confident that their performance will likely be near the average in the coming months.
• The Apex has a very long error bar. While its average sales are the highest, the large standard deviation indicates high volatility. Its performance one month was incredible, but in another, it lagged behind the others. This insight might prompt questions: What caused the sales spike in January? Was it a promotion that could be replicated, or an anomaly we can't count on?

This graph isn’t just showing numbers, it’s providing a narrative about performance and predictability that a simple bar chart just can’t deliver on its own.

Final Thoughts

Mastering the ability to add standard deviation bars to your graphs in Excel allows you to move beyond simple reporting of averages and into a more nuanced analysis of your data's reliability and consistency. It’s a technique that adds immediate professional depth to your reports and dashboards by revealing the story behind the numbers.

While Excel is a powerful tool, orchestrating these steps - from connecting data sources, to making calculations, to formatting charts - is often a manual and time-consuming process. At Graphed, we recognized that spending hours wrangling spreadsheets is time that could be better spent on strategy. That's why we built a tool that connects to your key data sources directly and lets you create complex dashboards and get answers just by asking questions. Instead of working through multi-step menus, our users can just ask, "Show me average sales by product for last quarter with standard deviation bars," and get back a live, interactive dashboard in seconds.