The dependable way to create a bell curve in Excel is to calculate density values with =NORM.DIST(x,mean,standard_deviation,FALSE), then plot the X and Y columns in Insert → X Y (Scatter) → Scatter with Smooth Lines. Use NORM.S.DIST for a standard curve, or calculate a dataset’s mean and standard deviation first for a fitted curve.
What a bell curve represents
A bell curve is a visual model of a normal distribution. It is usually symmetric around its mean: the mean sets the center, while the standard deviation controls the spread. The plotted Y-value is probability density (the curve’s height), not the probability of one exact value.
A fitted normal curve is theoretical. It can help compare observations with normal behavior, but drawing one does not prove that the underlying data is normally distributed. A histogram remains the direct view of the observed distribution.
Choose the right method
| Your situation | Use |
|---|---|
| Generic standard bell curve | Method 1 with NORM.S.DIST |
| Existing observations | Method 2 with AVERAGE, STDEV.S or STDEV.P, and NORM.DIST |
| Observed frequencies compared with expected normal behavior | Method 2 plus a scaled histogram overlay |
| Numerical probabilities rather than a chart | NORM.DIST(...,TRUE) or related functions |
Method 1: Create a standard bell curve without data
Use this method for a standard normal distribution with mean 0 and standard deviation 1. Microsoft defines NORM.S.DIST(z,cumulative) as the standard normal distribution; with FALSE, it returns density. See Microsoft’s NORM.S.DIST documentation.
#1 Best Overall
Build the calculation table
- In
A1, enter Z; inB1, enter Density. - Enter
-3inA2and-2.9inA3. InA3, you can instead use=A2+0.1, then fill down until the values reach 3. Use -4 to 4 if you want more visible tails. - In
B2, enter=NORM.S.DIST(A2,FALSE)and fill down beside the Z-values.
Optional dynamic-array shortcut
In Microsoft 365 or Excel 2024, enter =SEQUENCE(121,1,-3,0.05) in A2. In B2, enter =NORM.S.DIST(A2#,FALSE). The # refers to the spilled range. The fill-down method works when dynamic arrays are unavailable.
Plot the curve
- Select both columns, including their headers.
- Choose Insert → X Y (Scatter) → Scatter with Smooth Lines.
- Remove markers if Excel displays them.
- Add the title Standard Normal Bell Curve, label the horizontal axis Z-score, and label the vertical axis Probability density.
Scatter charts preserve numeric spacing on the horizontal axis; line charts treat X entries as equally spaced categories. Microsoft explains the distinction in its scatter-versus-line chart guidance.
Method 2: Fit a bell curve to existing observations
Assume the numeric observations occupy A2:A101. Keep headers outside that range and remove or investigate errors and unintended text.
Rank #2
- This guide is a perfect overview for the topics covered in introductory statistics courses.
Calculate the mean and standard deviation
Set up these cells:
| Cell | Entry |
|---|---|
| D1 | Mean |
| E1 | Standard deviation |
| D2 | =AVERAGE(A2:A101) |
| E2 | =STDEV.S(A2:A101) for a sample, or =STDEV.P(A2:A101) for the complete population |
Use STDEV.S when the observations are a sample from a larger population. Use STDEV.P when they represent the entire population being analyzed. The choice can materially affect a small-sample curve.
PC Slower Than It Used to Be?
A free scan shows the junk files, broken settings and background clutter dragging Windows down - then fixes them in one click.Free scan · Windows 10 & 11Crashes, No Sound, or Screen Glitches?
Random freezes, missing sound and display glitches usually trace back to one bad driver. Find and replace yours safely.Free scan · under a minuteGenerate evenly spaced X-values
- Enter X in
G1and Normal density inH1. - In
G2, enter=$D$2-3*$E$2. - In
G3, enter=G2+$E$2/10and fill down until the values reach approximately=$D$2+3*$E$2. Smaller steps make a smoother curve; larger steps can look angular.
For a fixed 121-point grid in Microsoft 365 or Excel 2024, use =SEQUENCE(121,1,$D$2-3*$E$2,6*$E$2/120) in G2.
Calculate density
In H2, enter =NORM.DIST(G2,$D$2,$E$2,FALSE) and fill down. The explicit FALSE selects the probability density function. Microsoft documents the syntax and the cumulative switch in NORM.DIST.
Rank #3
Create and format the chart
- Select the X and density columns.
- Choose Insert → X Y (Scatter) → Scatter with Smooth Lines.
- Remove markers, add a title such as Normal Curve Based on Sample Data, and add axis titles.
- Set sensible horizontal-axis bounds around the mean and format the vertical axis as decimals when appropriate.
Because the formulas reference the mean and standard deviation cells, changing the source observations recalculates the fitted curve. An evenly spaced X-axis is preferable to plotting unsorted source observations directly.
Overlay a normal curve on a histogram
A histogram displays observed counts in bins; a normal curve displays theoretical density. Their vertical scales differ, so an unscaled curve will usually appear far too low.
Free tools Windows power users keep installed
One-click scans. No signup required.
- Create a histogram from the source observations.
- Keep the fitted X and density table from Method 2.
- In a new curve column, multiply density by sample size and bin width:
=NORM.DIST(x,$D$2,$E$2,FALSE)*COUNT($A$2:$A$101)*bin_width. - Add the scaled values as a second series. Use an XY Scatter series with smooth lines for the curve and columns for the histogram.
- If the scales still differ, place the curve on a secondary axis and verify that the X positions and bin width match.
The factor sample size × bin width converts density into expected counts comparable with histogram columns.
Common problems and fixes
#NUM! in NORM.DIST
A standard deviation of zero or less is invalid. This occurs when all observations are identical or the standard-deviation reference is wrong. Check the range and confirm that it contains more than one distinct numeric value; do not force a normal curve onto constant data. See Microsoft’s invalid-argument note in NORM.DIST.
#VALUE! or implausible statistics
- Exclude headers from the calculation range.
- Check for error cells, text, blanks, and numbers stored as text.
- Use
COUNTto confirm the number of numeric observations. - Confirm that mean, standard-deviation, and X-value references point to the intended cells.
The result is S-shaped, not bell-shaped
You used the cumulative distribution. Replace TRUE with FALSE in NORM.DIST. TRUE answers the probability that a value is less than or equal to X and produces an S-curve.
The curve is jagged or stops early
Use more X-values—61 to 121 points is a practical starting range—and reduce the increment. Extend from ±3 to ±4 or ±5 standard deviations when tail visibility matters.
Best Value
The curve looks flat
A wide X-axis, a large standard deviation, or a histogram using a different scale can make the peak appear low. Narrow the displayed range around the mean and, for overlays, apply the sample-size and bin-width scaling.
The horizontal axis is wrong
Rebuild the chart as an XY Scatter chart. A line chart spaces category labels evenly, even when your numeric intervals are unequal. Microsoft’s chart guidance is available at this support page.
Analysis ToolPak is missing
The ToolPak is optional and is mainly useful for histogram and other analyses. On Windows, choose File → Options → Add-ins; in Manage, select Excel Add-ins → Go, check Analysis ToolPak, and select OK. On Mac, choose Tools → Excel Add-ins, check the add-in, select OK, and restart if prompted. The Data Analysis command then appears on the Data tab. See Microsoft’s activation instructions. Excel for the web may not expose the same add-in and chart controls as desktop Excel.
Which Excel function should you use?
| Need | Function | Result |
|---|---|---|
| Standard normal curve | NORM.S.DIST(z,FALSE) |
Density for mean 0 and standard deviation 1 |
| Curve with specified mean and spread | NORM.DIST(x,mean,standard_deviation,FALSE) |
Density height |
| Cumulative probability | NORM.DIST(x,mean,standard_deviation,TRUE) |
Probability up to X, shown as an S-curve if charted |
Older workbooks may contain NORMDIST and NORMSDIST. Microsoft retains these names for compatibility but recommends NORM.DIST and NORM.S.DIST; see NORMDIST and NORMSDIST.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Know the model’s limits
Before relying on the fitted curve, inspect the raw histogram. Strong skew, two or more modes, heavy tails, hard boundaries such as zero, mixed populations, influential outliers, or a very small sample can make a normal model misleading. Label the chart as a fitted or theoretical normal curve rather than claiming that the data is normal.
Excel is the natural choice when you need .xlsx compatibility, Excel-specific functions, the Analysis ToolPak, or the exact desktop workflow above. Microsoft offers subscription Microsoft 365 and one-time-purchase Office editions; verify current regional pricing and feature availability on Excel’s product page and the Microsoft 365 comparison page. For a one-off basic chart, Google Sheets, LibreOffice Calc, or Apple Numbers may be sufficient, but menus and function or add-in compatibility differ.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
