How to Create a Normal Distribution Graph in Excel

Creating a normal distribution graph in Excel, often called a bell curve, is an excellent way to visualize the spread of your data. This simple chart can help you quickly understand patterns, spot outliers, and see how values are clustered around an average. This tutorial will walk you through the entire process, from calculating your data’s core statistics to building a polished bell curve chart.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What is a Normal Distribution (Bell Curve)?

Before jumping into Excel, let’s quickly cover what a normal distribution is. Simply put, it's how some data sets tend to behave. Picture the heights of a large group of people, most will be around the average height, with fewer people who are extremely tall or extremely short. When you plot this out, it forms a symmetrical, bell-shaped curve.

This "bell curve" is defined by two key numbers:

• Mean: This is the average of all your data points. It represents the peak, or the center, of the bell curve.
• Standard Deviation: This measures how spread out your data is from the mean. A small standard deviation means your data is tightly packed around the average, creating a steep, narrow bell. A large standard deviation means the data is more spread out, resulting in a flatter, wider curve.

Understanding this concept helps you analyze everything from customer purchase values and website traffic to employee performance metrics, allowing you to see what’s typical, what’s common, and what’s an anomaly.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 1: Calculate Your Data's Mean and Standard Deviation

The first step is to calculate the two key stats that will define your bell curve's shape: the mean and the standard deviation. Let's use an example. Imagine you have a list of recent order values from your Shopify store, and you want to visualize their distribution.

Suppose your data is in column A, from cell A2 to A51.

1. Find the Mean (Average) Click on an empty cell where you want to display the mean. B2, for example. Type the following formula and press Enter:

=AVERAGE(A2:A51)

This instantly calculates the average of your data set.

2. Find the Standard Deviation Now, click on another empty cell, like C2. You will use the STDEV.S formula here. The ".S" stands for "sample," which you should use if your data represents a sample of a larger group (which is most common in business analysis). If your data represents the entire population, you'd use STDEV.P.

Type the following formula and press Enter:

=STDEV.S(A2:A51)

You now have the two critical components needed to build your graph. Store these values somewhere easy to reference, perhaps labeling them "Mean" and "StDev" in adjacent cells so you don't forget what they are.

Step 2: Set Up Your Data Points for the Curve

Unlike a standard bar chart that uses your raw data, a bell curve is a smooth line plotted over a range of values. To create it, we need to generate a set of data points - an "X" axis (the values being measured, like order value) and a "Y" axis (the probability, or height of the curve at each point).

First, create two new columns. Label them something like "Value (X-Axis)" and "Probability Density (Y-Axis)". Let's say these are in columns E and F.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Generating the X-Axis Values

A normal distribution curve technically stretches to infinity in both directions, but for practical purposes, about 99.7% of the data falls within three standard deviations of the mean. So, we'll create a range of data points that covers this spread.

1. Find your starting point: The lowest value on our chart should be about three to four standard deviations below the mean. In a cell at the top of your "Value" column (E2), type a formula to calculate this. If your mean is in C2 and standard deviation is in C3, the formula would be:

=C2 - (3 * C3)

1. Choose an increment: We need to fill the column with values heading towards the mean and beyond. The increment size determines how smooth your curve will be. A smaller increment creates a smoother line. A good starting point is around one-fifth or one-tenth of your standard deviation. Let's calculate this increment in another cell (say, D2) for easy reference:

=C3 / 5

1. Fill the column: Now, in the cell below your starting point (E3), type a formula to add the increment to the previous value:

=E2 + $D$2

Important: Using $D$2 with the dollar signs creates an absolute reference, so Excel will always look at cell D2 for the increment value as you drag the formula down.

1. Drag the fill handle (the small square at the bottom-right corner of cell E3) down for about 30-40 rows. This will generate a series of data points that go from three standard deviations below the mean to about three standard deviations above it, forming the horizontal axis of your graph.

Step 3: Calculate Probability Density with the NORM.DIST Formula

With our X-axis values ready, we can now calculate the corresponding Y-axis value for each point using Excel's powerful NORM.DIST function. This formula calculates the normal distribution for a specified mean and standard deviation.

The syntax for the formula is:

NORM.DIST(x, mean, standard_dev, cumulative)

• x: The value for which you want to calculate the distribution (your X-axis data points from column E).
• mean: The average of your data set (your value in C2).
• standard_dev: The standard deviation of your data set (your value in C3).
• cumulative: A logical value. Here's the key part:

Let's apply it. Click on the first cell of your "Probability Density" column (cell F2). Type the following formula:

=NORM.DIST(E2, $C$2, $C$3, FALSE)

Again, notice the use of absolute references ($C$2 and $C$3) for the mean and standard deviation, as these values won't change. The reference to E2 is relative because we want it to update for each new row.

Press Enter, then drag the fill handle for this cell all the way down to match your X-axis values. You will now have a column of numbers representing the height of the bell curve at each point.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 4: Create the Normal Distribution Graph

The hard work is done! Now it’s time for the easy and rewarding part: charting the data.

1. Select your data columns: Highlight all the data in both your "Value (X-Axis)" and "Probability Density (Y-Axis)" columns (E and F).
2. Insert the Chart: Go to the Insert tab on the Excel ribbon. In the Charts group, click on the Insert Scatter (X, Y) or Bubble Chart icon. From the available options, choose Scatter with Smooth Lines.

And that's it! Excel will instantly generate a bell curve based on your data.

From here, you can style the chart to your liking:

• Give it a descriptive title, like "Distribution of Online Order Values."
• Add axis titles to label what the X and Y axes represent.
• Adjust the colors, remove gridlines, or resize the chart to fit your dashboard or report.

Why is this Useful for Marketers and Business Owners?

Building a bell curve isn't just a statistical exercise, it's a practical tool for making better decisions:

• Audience Segmentation: Analyze data like time spent on site or customer lifetime value. Most users will be in the middle, but the curve helps you identify and understand the highly-engaged (or high-spending) outliers you should focus on.
• Campaign Performance: Plot your ad campaigns' return on ad spend (ROAS). Are most campaigns clustered around a predictable average, or do you have a few major winners and losers? This tells you whether your strategy is consistent or hit-or-miss.
• Inventory Management: For e-commerce stores, plotting the sales of different products can reveal which items have consistent, average demand versus those with wildly fluctuating sales, helping you manage stock more effectively.

Final Thoughts

Creating a beautiful normal distribution graph in Excel is a perfectly manageable task once you understand the steps. It involves calculating your mean and standard deviation, generating a range of data points, using the NORM.DIST formula to find the probability density, and then plotting the results with a Scatter with Smooth Lines chart. It transforms a flat list of numbers into a powerful visual insight.

While Excel is great for manual analysis, we know this process can feel time-consuming if you just need a quick answer. Our team built Graphed because we wanted to turn these multi-step reporting tasks into simple conversations. Instead of building formulas and generating plot points, you can just connect your sources like Shopify or Google Analytics and ask, "Show me a distribution of daily sales this quarter." We instantly build a live, interactive visualization for you, so you can spend your time acting on insights, not creating charts.