How to Add Standard Deviation in Excel Graph

You’ve already done the hard work of organizing your data and creating a chart in Excel, but a simple bar or line graph showing the average doesn’t always tell the whole story. To show how much your data points vary, you need to add the standard deviation. This article will show you exactly how to calculate standard deviation in Excel and then cleanly display it on your graph using error bars for a more accurate and insightful report.

Graphed

Still Building Reports Manually?

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

Watch the Demo

A Quick Refresher: What Is Standard Deviation?

Before we jump into the "how," let's quickly cover the "what." In simple terms, standard deviation is a number that tells you how spread out your data points are from the average (also known as the mean). A small standard deviation means your data is tightly clustered around the average, indicating consistency. A large standard deviation means the data is widely spread out, indicating significant variability.

Think about tracking a website's daily visitors:

• Low Standard Deviation: The daily visitor count is very consistent, maybe fluctuating between 950 and 1,050 visitors each day. The average of 1,000 is a reliable representation of daily traffic.
• High Standard Deviation: The visitor count is all over the place. One day you get 200 visitors, the next you get 3,000, and another day it's 500. The average might still be around 1,000, but it’s a misleading number because no single day is "average."

Displaying this on a graph is powerful because it adds crucial context. An average can hide risk and volatility. By visualizing the standard deviation, you immediately show your audience the range of likely outcomes, allowing them to better understand the consistency and reliability of the data presented.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 1: Calculate Standard Deviation in Excel

You can't add standard deviation to a graph without first calculating it in your worksheet. This is a straightforward process using one of Excel's built-in formulas. Let's start with a sample dataset. Imagine we're tracking quarterly sales for two different products: "Steady Performer" and "Volatile Star."

Here’s how our data looks in Excel:

First, we need to calculate the average and standard deviation for each product. Create two new columns for "Average Sales" and "Standard Deviation."

Choosing the Right Formula: STDEV.S vs. STDEV.P

Excel offers two main formulas for standard deviation:

• STDEV.S: Calculates the standard deviation based on a sample of a larger population. This is the one you will use almost all of the time in business reporting, as your data (e.g., quarterly sales) typically represents a sample of all possible outcomes.
• STDEV.P: Calculates the standard deviation for an entire population. You'd only use this if your dataset contained every single member of the group you are studying (e.g., test scores for every student in a class).

For our scenario, we'll use STDEV.S.

How to calculate:

1. Average sales for each product:
2. Standard deviation for each product:

Your data will now include columns for "Average Sales" and "Standard Deviation" with calculated values:

Notice that both products have the exact same average sales of $10,750. However, their standard deviations are wildly different. Now let's visualize this.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 2: Create a Basic Column Chart

We need a chart that displays the average sales for each product. The standard deviation will be added on top of that as error bars.

1. Select the cells containing the product names and their corresponding average sales values (for example, cells A2:A3 and F2:F3). Hold down Ctrl (or Cmd on Mac) to select non-adjacent columns.
2. Go to the Insert tab in the Excel ribbon.
3. In the Charts group, find and click the Column or Bar Chart icon.
4. Choose a simple 2-D Clustered Column chart.

You should now see a basic chart showing two columns of equal height, both at $10,750. On its own, this chart is misleading – it suggests both products perform identically.

Step 3: Add Standard Deviation Using Error Bars

This is where we add the much-needed context. We'll add error bars to represent the standard deviation we calculated.

1. Click on your chart to select it. When selected, you'll see a green + button appear in the top-right corner. This is the Chart Elements menu.
2. Click the + button to open the menu.
3. Check the box next to Error Bars. Excel will immediately add default, generic error bars to your chart. Do not stop here! These are not your actual standard deviation values yet.
4. To customize them, click the small arrow that appears to the right of "Error Bars" and select More Options….

This opens the Format Error Bars pane on the right side of your screen. This is where you connect your calculated values to the chart.

Navigating the 'Format Error Bars' Pane

In this pane, you have a few settings. The ones to focus on are under the Error Amount section:

• Fixed value / Percentage: Ignore these for our purpose. They apply a constant error value to every bar.
• Standard deviation: This sounds like what you want, but it can be unreliable. It tells Excel to recalculate standard deviation on its own based on the charted values (the averages), not your raw data. For full control and accuracy, it's best to use the Custom option.
• Custom: This is the option we want. It lets you tell Excel precisely which values to use for the error bars.

Step 4: Specifying Your Custom Error Bar Values

This is the final and most important step. Here, we link the error bars on the chart to the standard deviation values you calculated back in Step 1.

1. In the Format Error Bars pane, select the Custom radio button under "Error Amount" and then click the Specify Value button.
2. A small dialog box titled Custom Error Bars will appear. It has two fields: Positive Error Value and Negative Error Value.
3. Delete the default contents inside the Positive Error Value box (it usually says ={1}).
4. With your cursor still in that box, click and drag to select the cells in your worksheet that contain your calculated standard deviation values. In our example, this would be cells G2:G3.
5. Do the exact same for the Negative Error Value box. Delete its contents and select the same cells (G2:G3).
6. Click OK.

Instantly, the error bars on your chart will resize. The bar for "Steady Performer" will have tiny error bars, while the "Volatile Star" bar will have massive ones stretching far above and below the average.

Graphed

Still Building Reports Manually?

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

Watch the Demo

How to Interpret Standard Deviation on a Graph

Congratulations, you now have a chart that tells a complete and honest story! Here's how to read it:

Each column still shows the same average quarterly sales of $10,750.

• For the Steady Performer, the tiny error bars (representing ±$479.58) show that in any given quarter, sales were consistently very close to a predictable average. This product is reliable.
• For the Volatile Star, the huge error bars (representing ±$10,531.70) visually scream instability. While its average is high, its actual performance swings from disastrously low to fantastically high. This product is unpredictable and risky.

You can clearly see that despite sharing an average, these two products represent entirely different business realities. This is the kind of insight that helps teams make smarter decisions – whether to invest more in a risky but potentially high-reward product or to rely on the consistent performer for stable revenue.

Final Thoughts

Learning how to add standard deviation to an Excel graph transforms your charts from simple summaries into insightful analytical tools. By using custom error bars linked to your calculated STDEV.S values, you can provide a much clearer picture of your data's variability and help your team look beyond the averages to see the real story.

While Excel is fantastic for detailed analyses like this, keeping up with reporting across multiple apps – like Google Analytics, Shopify, and your CRM – often means your day is spent manually wrestling with CSVs. At our company, we designed Graphed to remove this friction entirely. We hook directly into your data sources so you can create live dashboards and get analysis just by asking questions in plain English, giving you back time to focus on strategy instead of tedious spreadsheet updates.