Creating a normal distribution in Excel means building a bell curve from your data

A normal distribution is a bell-shaped curve that shows how your data spreads around an average. Excel does not have a single button for this, but you can build one in about five minutes using a formula, a data column, and a chart. The result looks like a smooth hill — most of your values cluster near the middle, and fewer values appear at the extremes.

You will need three things: a column of numbers spaced evenly across your data range, a formula that calculates the height of the curve at each point, and a chart type that plots those heights. This guide walks you through each step in order.

Key Takeaways

  • A normal distribution curve requires two columns: one with evenly spaced numbers across your data range, and one with the NORM.DIST formula applied to each number.
  • The NORM.DIST function takes four inputs: the value you are testing, the average of your data, the standard deviation, and FALSE (to get the height of the curve, not cumulative probability).
  • An XY Scatter chart with smooth lines displays the curve correctly; a bar or column chart will not show the bell shape properly.
  • You can adjust the curve's position and width by changing the average and standard deviation values in the formula.

Set up your data columns

Start with your actual data in one column — say, column A, rows 2 through 50. Calculate the average using =AVERAGE(A2:A50) and the standard deviation using =STDEV(A2:A50). Write these two numbers in empty cells where you can see them; you will reference them in your formula.

In column C, create a series of evenly spaced numbers that span your data range. If your data runs from 10 to 90, start at 10 in C2 and increment by 1 or 2 in each row below. You can type the first two numbers (10, 11) and then select both cells and drag down to auto-fill the rest. Stop when you reach or pass 90. This column represents the x-axis of your curve — the possible values your data could take.

Add the NORM.DIST formula

In column D, row 2, type the formula =NORM.DIST(C2, average_cell, stdev_cell, FALSE). Replace "average_cell" with the actual cell holding your average (for example, E2) and "stdev_cell" with the cell holding your standard deviation (for example, E3). The FALSE at the end tells Excel to return the height of the curve at that point, not the cumulative probability.

An example formula looks like this: =NORM.DIST(C2, $E$2, $E$3, FALSE). Use dollar signs ($) before the column and row numbers in E2 and E3 so those references stay fixed when you copy the formula down. Press Enter, then select D2 and drag down to match the number of rows in column C. Each cell in column D now holds the height of the bell curve at the corresponding x-value in column C.

Create the chart

Select both columns C and D, including headers. Go to the Insert tab and choose Chart. In the chart type menu, select XY (Scatter) and then the option that shows a smooth curve without dots. Click Next or Finish depending on your Excel version.

The chart will appear on your sheet showing a bell curve. If it looks jagged or blocky instead of smooth, you selected the wrong chart type — go back and choose the smooth line option under XY Scatter. The x-axis should show your data range (10 to 90 in the example above), and the curve should peak near your average value.

Adjust the curve to match your data

The curve's position and width depend on the average and standard deviation you entered. If you want to see how the curve changes, edit the numbers in the cells you used for average and standard deviation. The chart updates automatically. A higher average shifts the peak to the right; a larger standard deviation makes the curve wider and flatter.

You can also change the spacing in column C to zoom in or out. If you want a tighter view of just the middle of your data, use smaller increments (0.5 instead of 1). If you want to see the full spread including the thin tails, use larger increments and extend the range further in both directions.

Format the chart for clarity

Right-click the chart and select Edit Chart (or double-click it). Right-click the curve itself and choose Format Data Series. You can change the line color, thickness, or style. Add a title by clicking the chart title area and typing a new name — something like "Distribution of Test Scores" makes it clear what the curve represents.

Click the axis labels to format them as well. You can adjust the number of decimal places, the font size, or the range shown. When you are done, click outside the chart to exit edit mode. The chart is now part of your spreadsheet and will update if you change the data or formula values.

Common mistakes and how to fix them

If your curve looks like a flat line or a single spike, check that you used FALSE in the NORM.DIST formula, not TRUE. TRUE returns cumulative probability, which produces a different shape. Also verify that your standard deviation is not zero — if all your data is identical, the formula cannot create a curve.

If the chart shows dots instead of a smooth line, you selected a scatter plot without the smooth option. Delete the chart and create a new one, making sure to pick the XY Scatter type with the smooth curve icon. If the curve appears in the wrong place, double-check that your average and standard deviation formulas are calculating correctly by clicking on the cells and reviewing the formula bar.

Frequently Asked Questions

What is the difference between NORM.DIST and NORM.S.DIST?

NORM.DIST works with any average and standard deviation you provide. NORM.S.DIST is for a standardized normal distribution with an average of 0 and standard deviation of 1. Use NORM.DIST for your actual data.

Can I create a normal distribution from raw data without calculating average and standard deviation myself?

Yes. Instead of typing the average and standard deviation into separate cells, you can put the formulas directly into NORM.DIST: =NORM.DIST(C2, AVERAGE($A$2:$A$50), STDEV($A$2:$A$50), FALSE). This works the same way but keeps everything in one formula.

Why does my curve not match the shape of my actual data?

A normal distribution assumes your data follows a bell curve pattern. If your actual data is skewed (bunched on one side) or has multiple peaks, the theoretical normal distribution will not match it exactly. The curve shows what a perfect bell shape would look like with your data's average and spread.

Can I overlay my actual data on top of the normal distribution curve?

Yes. Create a histogram of your raw data, then add the normal distribution curve as a second data series. Right-click the chart, select Add Data, and choose your column D (the NORM.DIST results). This lets you compare how closely your real data follows the theoretical curve.