In Excel: compute the mean and standard deviation, build a column of x values across the range, get the height of the curve with =NORM.DIST(x, mean, sd, FALSE), then plot x against that column as a Scatter with Smooth Lines.
On this page7
Mean = 70.714 · Std deviation = 5.992
What this does
A bell curve is the plot of the normal distribution defined by your data's mean and standard deviation. Excel has no "insert bell curve" button, so you build it: AVERAGE and STDEV.S give the two parameters, a column of evenly spaced x values spans roughly mean ± 3 standard deviations, and NORM.DIST with its last argument set to FALSE returns the probability density — the curve's height — at each x. Setting that argument to TRUE instead gives the cumulative S-curve. Plotting the result needs Scatter with Smooth Lines; a line chart treats the x values as categories and distorts the shape. Keep the inputs visible and clearly labelled and the whole thing stays auditable — anyone who opens the file later, including you, can see at a glance exactly what feeds the result and change one assumption without hunting through the formula. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “create a normal distribution curve in excel”. Start on a copy or a tiny sample, keep the affected cells visible, and compare the result with the tool above before you touch the real workbook. When a formula is involved, keep the inputs labelled beside it, reference cells instead of typing values, and apply number formatting only after the result checks out. The point is a layout choice that keeps the sheet readable and sortable, but the practical win is that someone else can open the file and understand what happened without asking you.
A worked example
200 test scores in A2:A201. D1 = =AVERAGE(A2:A201) → 72.4, D2 = =STDEV.S(A2:A201) → 11.8. In F2 put =$D$1-3*$D$2 and in F3 =F2+($D$2*6/60), filled down to F62 — 61 points spanning ±3σ. In G2: =NORM.DIST(F2, $D$1, $D$2, FALSE), filled down. Select F2:G62 and Insert ▸ Scatter ▸ Scatter with Smooth Lines. The peak sits at 72.4 and the curve is near zero by 37 and 108. A bell curve is how a set of measurements gets turned into a statement about how likely a value is — grading, quality limits and process control all start with the mean, the standard deviation and this shape. If there is any chance you will reuse this, drop it into a small template tab right now: a labelled input area on the left and the formula beside it, checked once against the tool above. Next time the same question comes up, the answer is a single paste away instead of a rebuild from memory.
In Google Sheets
Google Sheets handles this almost identically to Excel. The formula syntax above is the same, and the menu lives under a slightly different label rather than a ribbon tab. Use the platform toggle at the top of the page to switch every keyboard shortcut between Windows and Mac, and expect at most cosmetic differences in naming. Nothing on this page is behind a login: the tool runs entirely in your browser, the formula is shown in full with one-click copy, and the steps work the same on Windows and Mac. That is the whole promise here — the exact answer, a way to prove it on your own numbers, and just enough context to make it stick. The short version of “create a normal distribution curve in excel”: the answer is at the top of this page, the tool proves it on your own numbers, and the sections above explain why it holds so the next variation does not stump you. Excel rewards people who reference cells instead of typing values and who keep inputs separate from formulas, because that is what makes a result you can audit months later. Build it once, deliberately, with the live tool as a check, and you convert a one-off lookup into a reusable skill — which is the whole point of learning the why and not just the what.
Common mistakes
- Using a Line chart instead of a Scatter chart, which spaces the x values evenly by position and misshapes the curve.
- Passing TRUE as the fourth
NORM.DISTargument, which draws the cumulative distribution rather than the bell. - Using STDEV.P on a sample; STDEV.S is the right choice unless the data really is the whole population.
- Plotting a bell curve over data that is visibly skewed or bimodal, which asserts a normality the data does not have.
- Leaving the x values unsorted, which makes the smooth line double back on itself.
Frequently asked questions
How do I make a bell curve in Excel?
Compute the mean and standard deviation, build a column of x values across mean ± 3 standard deviations, calculate =NORM.DIST(x, mean, sd, FALSE) beside it, and plot the two columns as a Scatter with Smooth Lines.
What does the FALSE argument do in NORM.DIST?
It asks for the probability density — the height of the bell at that x. TRUE returns the cumulative probability instead, which draws an S-shaped curve.
How do I overlay my actual data?
Add a histogram of the raw values as a second series and put it on a secondary axis. Counts and probability densities are not on the same scale, so one axis would flatten the curve.
How wide should the x range be?
Mean ± 3 standard deviations covers about 99.7% of a normal distribution, which is enough for the curve to reach the baseline at both ends.
Other ways people ask this
On the way here you may have searched this as “create a normal distribution curve excel”, “create normal distribution curve in excel”, “creating normal distribution curve in excel” and “excel graph normal distribution curve” — it is all the same task, and this page is the single, complete answer to it.
Why do people search for this in so many different ways?
Because the same task has many names. “create a normal distribution curve excel”, “create normal distribution curve in excel”, “creating normal distribution curve in excel” all point at the one operation explained on this page, which is why they all lead here.