How to Plot a Bell Curve in Excel (and a 30-Second Shortcut)

You have a column of numbers: test scores, delivery times, product weights, or heights. Someone asks, "Is this normal? Where do most values fall?" A bell curve answers that in one picture.

The problem is that Excel has no "bell curve" chart button. You have to calculate the curve yourself and then turn it into a chart. This guide shows you both ways to do it, so you can pick the one that fits your time.

What is a bell curve?

A bell curve is a smooth chart of a normal distribution. It shows how values spread around the average. Most values sit near the middle, and fewer values appear as you move to either side.

Two numbers define every bell curve:

• Mean: the average. It sets where the peak sits.
• Standard deviation (SD): the typical distance from the average. It sets how wide the curve is.

Once you know those two numbers, you can also use the 68-95-99.7 rule. About 68% of values fall within 1 SD of the mean, 95% within 2 SD, and 99.7% within 3 SD.

For a deeper look at SD itself, see this guide to standard deviation in Excel.

The example file

Both methods below use the same public dataset: weight-height.csv. It has 10,000 rows and three columns.

Height is in inches. The goal is simple: plot the height bell curve for men and women on the same chart and see how far apart they are.

Method A: Plot a bell curve in Excel by hand

This works in any recent version of Excel. Plan on 15 to 30 minutes the first time, longer with two groups.

Step 1: Calculate the mean and standard deviation

Put these formulas in empty cells. The example assumes Gender is in column A and Height in column B, rows 2 to 10001.

Male mean:    =AVERAGEIF(A2:A10001,"Male",B2:B10001)
Male SD:      =STDEV.S(IF(A2:A10001="Male",B2:B10001))
Female mean:  =AVERAGEIF(A2:A10001,"Female",B2:B10001)
Female SD:    =STDEV.S(IF(A2:A10001="Female",B2:B10001))

With one group only, you can use =AVERAGE(B2:B10001) and =STDEV.S(B2:B10001).

For this file you should see a male mean of about 69.03, SD 2.86, and a female mean of about 63.71, SD 2.70.

Step 2: Build a column of x-values

The chart needs points along the x-axis. Start about 3 SD below the lowest mean and end about 3 SD above the highest mean.

For heights, 54 to 80 inches in steps of 0.5 works well. Type 54 in D2, then in D3:

=D2+0.5

Fill down until you reach 80.

Step 3: Calculate the curve height with NORM.DIST

In E2, calculate the male curve. In F2, calculate the female curve. Replace the cell references with the cells that hold your mean and SD.

E2: =NORM.DIST(D2, $H$2, $H$3, FALSE)
F2: =NORM.DIST(D2, $H$4, $H$5, FALSE)

The last argument must be FALSE. That returns the curve height (the density). TRUE returns a running total, which draws an S-shape instead of a bell.

Fill both formulas down to match the x-values.

Step 4: Insert a smooth-line scatter chart

1. Select columns D, E, and F.
2. Go to Insert > Charts > Scatter > Scatter with Smooth Lines.
3. Name the series "Male" and "Female".
4. Label the x-axis "Height (inches)".
5. Optional: add a vertical line at each mean with an extra two-point series.

You now have a bell curve. It works, but every new file or group means repeating the helper columns and chart setup.

Method B: Plot a bell curve with one sentence in RowSpeak

RowSpeak is an AI workspace for Excel and CSV files. Instead of building helper columns, you describe the chart you want and RowSpeak does the calculations and drawing.

Here is the real recording, using the same weight-height.csv file:

Step 1: Upload your file

Open RowSpeak and drag in your Excel or CSV file. It reads the columns and finds the numbers you want to plot.

Step 2: Ask for the chart

Type your request in plain English:

Plot bell curves of height for male and female on the same chart.

RowSpeak shows its plan before it starts: confirm the height data by gender, generate the overlaid bell curves, then deliver the chart and a summary.

Step 3: Review the result

You get a "Height Distribution by Gender" chart with both curves, a dashed line at each mean, and a hover tooltip. Under the chart, RowSpeak writes what the curves show:

• Male: mean 69.03 in, SD 2.86 in.
• Female: mean 63.71 in, SD 2.70 in.
• The two curves have nearly the same shape. The female curve sits about 5.3 inches to the left.
• They overlap moderately between roughly 60 and 72 inches.

You can keep the conversation going. Ask it to shade the ±1, ±2, and ±3 SD ranges, switch to centimeters, or change the colors. You can also try this on the bell curve graph maker page with a sample file.

Prompts you can copy

Replace the column names with the ones in your file.

Plot a bell curve of the Score column. Mark the mean and show the ±1, ±2, and ±3 standard deviation ranges.

Overlay a normal curve on a histogram of Delivery Time and tell me if the data looks normally distributed.

Plot a bell curve of Order Value and list the rows that are more than 2 standard deviations from the mean.

Plot a bell curve of exam scores and show which scores fall into A, B, C, D, and F if grades follow the 68-95-99.7 rule.

How to check your bell curve before you share it

A bell curve looks convincing even when it is wrong for the data. Run these checks first.

1. Does the data have one peak? Plot a histogram first. If it shows two humps or a long tail on one side, a bell curve will mislead. This histogram guide shows how to make one.
2. Do the mean and SD match your file? Compare them with a quick AVERAGE and STDEV.S, or ask RowSpeak to show the numbers in a table.
3. Is the sample big enough? With fewer than about 30 values, a smooth curve suggests more certainty than you have. Show the raw values instead.
4. Does the 68-95-99.7 rule roughly hold? In the example file, 68.9% of men fall within 1 SD and 95.4% within 2 SD. If your shares are far off, the data is probably not normal.

Common mistakes

• Using TRUE in NORM.DIST. You get an S-shaped cumulative curve, not a bell.
• Choosing a line chart instead of a scatter chart. A line chart treats x-values as labels, so uneven steps distort the curve.
• Too few x-values. Steps that are too wide make the curve look jagged. Use at least 40 to 60 points across the range.
• Plotting skewed data as a bell. Income, prices, and order values usually have a long right tail. Use a histogram for those.
• Mixing groups. Heights of men and women together form one wide curve that describes neither group. Split by group first.

Which method should you use?

Use Excel by hand if you need a template that lives inside a workbook and you plot the same column often.

Use RowSpeak if you want the chart now, need to compare groups, or want a written explanation you can paste into a report. It is also the faster path when the next file arrives with different columns.

If your goal is a clear bell curve from your own data, start with the file you already have. Upload it to the RowSpeak bell curve graph maker, ask for the curve in one sentence, and review the mean and SD before you share it.