How to Create a Bell Curve in Excel

What a bell curve shows and why you might need one

A bell curve in Excel is a graph that shows how data spreads around an average. It looks like a smooth hill — most of your data clusters in the middle, and fewer items appear at the far edges. You build it by plotting a normal distribution, which is a mathematical pattern that appears in real life: test scores in a classroom, heights of adults, manufacturing tolerances, measurement errors.

You create a bell curve when you want to see whether your data follows this expected pattern, or when you need to show someone else what that pattern looks like. It is not the same as a bar chart or a line graph. Those show you what actually happened. A bell curve shows you the theoretical shape your data should take if it follows a normal distribution.

Key Takeaways

A bell curve requires two pieces of information: the average (mean) of your data and how spread out it is (standard deviation).
You calculate the curve using the NORM.DIST function in Excel, which takes a value, the mean, the standard deviation, and FALSE as inputs.
The curve itself is an XY scatter chart with a smooth line, not a bar or column chart.
You need a range of x-axis values (usually spread across several standard deviations) to create the smooth hill shape.

Calculate the mean and standard deviation of your data

Before you draw the curve, you need two numbers from your actual data. The mean is the average — add all your values and divide by how many you have. In Excel, use the AVERAGE function. The standard deviation tells you how spread out your data is. In Excel, use STDEV.S for a sample of data or STDEV.P if you have the entire population.

Put these calculations in empty cells where you can see them. For example, if your data is in cells A2 through A50, type =AVERAGE(A2:A50) in cell C2 and =STDEV.S(A2:A50) in cell C3. Write down these numbers or keep them visible — you will use them in the next step.

Create a column of x-axis values for the curve

The bell curve needs a range of values along the bottom (x-axis) to plot against. These values should spread across the middle of your data, roughly from three standard deviations below the mean to three standard deviations above it. This range captures about 99.7 percent of a normal distribution.

In a new column, create a series of numbers. Start in the first cell with a formula like =C2-(3*C3), where C2 is your mean and C3 is your standard deviation. This gives you the starting point. In the cell below, type =D2+0.5 (or another small increment). Copy this formula down 50 to 100 rows. You now have a column of evenly spaced values that will form the bottom of your chart.

Use NORM.DIST to calculate the curve height at each point

Next to your x-axis values, create a column for the curve heights. In the first cell of this new column, type =NORM.DIST(D2,$C$2,$C$3,FALSE). Here, D2 is the x-axis value, $C$2 is your mean (the dollar signs lock it so it does not change when you copy), $C$3 is your standard deviation, and FALSE tells Excel to give you the exact height, not a cumulative probability.

Copy this formula down to match all your x-axis values. Excel now calculates how tall the curve should be at each point along the bottom. The values will be small decimals — that is correct. The curve is a probability distribution, so the heights represent likelihood, not counts.

Select your data and insert an XY scatter chart

Highlight both columns: your x-axis values and your calculated curve heights. Include the headers if you have them. Go to the Insert tab and choose XY (Scatter) chart, not a bar or line chart. Select the option that shows points connected by smooth lines, not just dots or jagged lines. Excel creates a chart that looks like a rough bell shape.

If the curve looks jagged instead of smooth, you did not create enough x-axis values. Go back and add more rows to your calculation columns, or use a smaller increment (like 0.1 instead of 0.5) in your x-axis formula.

Adjust the chart to make it clearer

Right-click the chart and choose Edit Data or Select Data to add titles and labels. Give your chart a title that says what it shows. Label the x-axis with the name of what you measured (test scores, heights, weight). You can delete the y-axis label since it represents probability density, which most viewers do not need to understand.

If you want to overlay your actual data on top of the curve to compare them, add a third column with your original data values and add it as a second data series to the chart. This shows whether your real data actually follows the bell curve shape or deviates from it.

Overlay your actual data on the bell curve

To see how well your real data matches the theoretical curve, you can plot both together. Create a histogram of your actual data using the same x-axis range. In Excel, go to Insert, choose Histogram, and select your original data column. Then edit the chart to use the same bin width as your x-axis increment.

Alternatively, add your actual data as a second series to your scatter chart. Right-click the chart, select Select Data, and click Add. Choose your original data column. Excel plots both the smooth curve and your actual values on the same graph, making it straightforward to see where they match and where they diverge.

Frequently Asked Questions

What is the difference between NORM.DIST with TRUE and FALSE?

FALSE gives you the probability density — the height of the curve at each point. TRUE gives you the cumulative probability — the total likelihood of getting a value at or below that point. For a bell curve graph, always use FALSE.

Why does my curve look flat or barely visible?

The y-axis scale is probably too large. Right-click the y-axis, choose Format Axis, and set the maximum to something smaller, like 0.5 or 0.1. The curve heights are small decimals, so Excel often scales the axis too wide.

Can I create a bell curve without my own data?

Yes. You only need a mean and standard deviation. You can use any numbers you choose — for example, a mean of 100 and a standard deviation of 15 to show what a typical test score distribution looks like. You do not need actual data to draw the theoretical curve.

What if my data does not look like a bell curve when I overlay it?

Your data may not follow a normal distribution, which is common. Some real-world measurements are skewed (lopsided) or have multiple peaks. The bell curve shows what normal looks like; your actual data tells you whether your situation is normal or unusual.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.