Creating a normal curve in Excel requires sample data, a helper column for the bell curve formula, and a scatter chart
A normal curve (also called a bell curve) shows how data spreads around an average. Excel does not have a built-in normal curve button, but you can create one in about five minutes using the NORM.DIST function and a scatter chart. You need three things: your actual data in one column, a helper column with calculated values, and a chart type that plots both.
The process works the same whether you have 20 data points or 200. The curve itself does not change based on your data — it always shows the theoretical distribution. What changes is how well your actual data matches that curve, which is why plotting both together is useful.
Key Takeaways
- NORM.DIST calculates the height of the bell curve at each point; you enter your data's average and standard deviation once, then copy the formula down.
- Create a helper column with values spaced evenly across your data range (usually from the minimum to maximum value), then use NORM.DIST to calculate the curve height at each point.
- A scatter chart with two series — one for your actual data and one for the calculated curve — shows how closely your data matches a normal distribution.
- If your data is skewed or has outliers, the curve will not match the data points, which tells you the distribution is not normal.
Set up your data and calculate the average and standard deviation
Start with your data in a single column — say, column A, rows 2 through 50. Before you build the curve, you need two numbers: the average (mean) and the standard deviation. These describe the shape and position of your curve.
In an empty cell, calculate the average using =AVERAGE(A2:A50). In another empty cell, calculate the standard deviation using =STDEV.S(A2:A50) (use STDEV.S for a sample, STDEV.P if your data is the entire population). Write down or remember these cells — you will reference them in the next step. For example, if your average is in cell D2 and your standard deviation is in cell D3, you will use those references in your formula.
Create a helper column with evenly spaced values
The normal curve is smooth, so you need many points along it. Create a new column (say, column B) with values spaced evenly from the lowest to the highest value in your data. If your data ranges from 10 to 90, you might create values like 10, 11, 12, 13, and so on up to 90.
The easiest way is to type the first value (10) in cell B2, then type the second value (11) in cell B3. Select both cells, then drag the fill handle (the small square at the bottom right of the selection) down to row 51. Excel will continue the pattern automatically. If you have 50 data points, create 50 or more helper values — the more you have, the smoother your curve will look.
Use NORM.DIST to calculate the curve height at each point
In column C, you will calculate the height of the normal curve at each helper value. In cell C2, enter the formula =NORM.DIST(B2,$D$2,$D$3,FALSE). Replace D2 with the cell containing your average and D3 with the cell containing your standard deviation. The dollar signs ($) lock those references so they do not change when you copy the formula down. The FALSE at the end tells Excel to calculate the probability density (the height), not the cumulative probability.
Press Enter, then copy this formula down to match the number of helper values you created. If you have helper values in B2 through B51, copy the formula in C2 down to C51. The curve values will appear in column C — they will be small decimals, which is normal.
Create a scatter chart to display the curve and your data
Select your original data (column A) and your calculated curve values (columns B and C together). The easiest way is to click on column A header, then hold Ctrl and click on column B header, then hold Ctrl and click on column C header. Go to the Insert tab and choose Scatter Chart (the icon shows dots on a grid). Select the "Scatter with Straight Lines" or "Scatter with Smooth Lines" option — smooth lines will make the curve look more like a traditional bell curve.
Excel will create a chart with your data points and the curve on the same plot. If the curve and data points are hard to see together, you can adjust the chart by right-clicking on one series and choosing "Format Data Series" to change the color or line style of either the curve or the data points.
Adjust the chart to make the curve clearer
By default, the chart may show your data points and the curve in a way that makes it hard to see the pattern. Right-click on the data series (the dots representing your actual data) and choose "Format Data Series." Change the marker size to make the points more visible, or change the line color of the curve to make it stand out from the data.
You can also add a title and axis labels to make the chart easier to read. Right-click on the chart, choose "Add Chart Element," then add a title like "Data Distribution vs. Normal Curve." This makes it clear what you are looking at, especially if you are sharing the chart with others.
Interpret what the chart shows
Once your chart is complete, compare the data points to the curve. If the points cluster closely around the curve, your data is approximately normally distributed. If the points are scattered far from the curve, or if they bunch up on one side, your data is skewed or does not follow a normal distribution.
This matters because many statistical tests assume normal distribution. If your data is not normal, those tests may give misleading results. A normal curve chart is a quick visual way to check this assumption before you use your data in further analysis.
Frequently Asked Questions
What is the difference between NORM.DIST with TRUE and FALSE?
FALSE calculates the probability density (the height of the curve at that point), which is what you see in a bell curve chart. TRUE calculates the cumulative probability (the total percentage of data below that point), which creates an S-shaped curve instead. For a normal curve chart, always use FALSE.
Can I create a normal curve without my own data?
Yes. You only need an average and standard deviation. Create a helper column with evenly spaced values, then use NORM.DIST with your chosen average and standard deviation. You do not need actual data points — the curve will show the theoretical distribution for those parameters.
Why does my curve look jagged instead of smooth?
You do not have enough helper values. Go back to column B and add more values between your minimum and maximum. Instead of jumping by 1, try jumping by 0.5 or 0.1. The more points you calculate, the smoother the curve will appear in the chart.
What if my data has outliers that make the chart hard to read?
Outliers can stretch the chart and make the curve hard to see. You can adjust the axis limits by right-clicking on the axis, choosing "Format Axis," and setting a minimum and maximum value that excludes the extreme outliers. This does not remove the outliers from your data — it just zooms in on the main cluster.
Can I overlay multiple normal curves on the same chart?
Yes. Create separate helper columns and NORM.DIST calculations for each curve (using different averages or standard deviations), then add all of them to the same scatter chart. This is useful for comparing how different groups or datasets distribute.