How to Create a Bell Curve in Excel Using Your Own Data

Creating a bell curve in Excel means building a normal distribution graph from a dataset or formula

A bell curve (also called a normal distribution curve) is a graph shaped like a bell that shows how data spreads around an average. In Excel, you build one by calculating the normal distribution values for a range of numbers, then plotting those values as a chart. The process takes about 10 minutes and uses Excel's built-in NORM.DIST function paired with a line chart.

You do not need to install add-ins or use complex macros. The standard approach works in Excel for Windows, Excel for Mac, and Excel Online. You will create two columns of numbers — one for your data points along the horizontal axis, and one for the probability values that form the curve — then insert a chart.

Key Takeaways

A bell curve in Excel uses the NORM.DIST function to calculate probability values across a range of numbers centered on your average.
You need three pieces of information: the mean (average) of your data, the standard deviation (how spread out it is), and the range of values to display.
Create two columns — one with your data points, one with NORM.DIST formulas — then insert a line chart to visualize the curve.
The curve will be symmetrical around your mean, with the peak at the center and tails that extend left and right.

Setting up your data columns

Start by opening a blank area in your spreadsheet. In column A, you will list the data points that form the horizontal axis of your bell curve. In column B, you will calculate the probability for each point.

For example, if you want a bell curve centered on 100 with a standard deviation of 15, create data points from roughly 55 to 145 (which covers most of the curve). Type 55 in cell A1, then 56 in A2. Select both cells, grab the fill handle (small square at the bottom right of the selection), and drag down to A91. This creates a series counting up by 1 from 55 to 145. If you prefer larger or smaller steps, use 60, 70, 80, 90, 100, 110, 120, 130, 140 instead — fewer points create a rougher curve, but it still works.

The range you choose depends on your data. If your mean is 100 and standard deviation is 15, going from 55 to 145 captures about 99.7% of the distribution. For a mean of 50 with standard deviation of 10, use 20 to 80. The wider your range, the flatter the curve appears; the narrower, the taller and sharper it looks.

Calculating the normal distribution values

In cell B1, type the formula =NORM.DIST(A1,100,15,FALSE). Replace 100 with your actual mean and 15 with your actual standard deviation. The FALSE at the end tells Excel to return the probability density (the height of the curve at that point), not the cumulative probability. If you use TRUE, you will get a different shape that is not a bell curve.

Press Enter. Cell B1 now shows a decimal number — this is the height of the curve at the data point in A1. Copy this formula down to match all your data points. Click B1, then drag the fill handle down to B91 (or however many rows you created). Excel automatically adjusts the A1 reference in each row, so A2 pairs with B2, A3 with B3, and so on.

If your mean or standard deviation changes, you can edit the formula in B1 and copy it down again. The curve will recalculate instantly. Some people prefer to put the mean and standard deviation in separate cells (like D1 and D2) and reference those in the formula — =NORM.DIST(A1,$D$1,$D$2,FALSE) — so they can change the values without editing the formula itself.

Inserting and formatting the chart

Select the data in columns A and B (both columns, all rows with data). Click the Insert tab, then choose Chart. Excel opens the chart wizard. Select XY (Scatter) chart type, then choose the "Scatter with Smooth Lines" option (not the one with dots). This creates a smooth curve instead of jagged points.

Click Next. On the Data Range screen, confirm that your data range is correct — it should show something like $A$1:$B$91. Click Next again. On the Chart Title screen, give your chart a name like "Normal Distribution" or "Bell Curve". You can also add axis titles: "Value" for the horizontal axis and "Probability Density" for the vertical axis. Click Finish.

The chart appears in your spreadsheet. Right-click the curve line itself and select "Format Data Series". Under Line Color, choose a solid color — blue or black works well. Adjust the line width to 2 or 2.5 points so the curve is visible. If you want to remove the dots where data points sit, set the marker to "None". Click Close.

Adjusting the appearance and scale

By default, Excel may add gridlines and a legend that you do not need. Right-click the chart background and select "Format Chart Area". Under Fill, choose "No Fill" to make the background white or transparent. Right-click the legend (the box listing the data series) and delete it.

If the curve looks too flat or too tall, the issue is usually the scale of the vertical axis. Right-click the vertical axis (the numbers on the left side) and select "Format Axis". Under Axis Options, you can set the minimum and maximum values manually. For a cleaner look, set the minimum to 0 and the maximum to a value slightly higher than your tallest point — usually 0.03 or 0.04 for standard bell curves.

You can also add a horizontal line at the mean to show where the peak sits. Right-click the chart, select "Select Data", then "Add". Create a new series with just two points: the mean value paired with the maximum probability value, and the mean value paired with 0. Format this line as a dashed line in a light gray color.

Using a bell curve with your actual data

If you have a real dataset and want to overlay a bell curve on top of it, first calculate the mean and standard deviation of your data. Use =AVERAGE(your data range) and =STDEV(your data range). Then build the bell curve as described above, using those calculated values in the NORM.DIST formula.

To show both your actual data and the theoretical bell curve on the same chart, create a histogram of your data first, then add the bell curve as a second series. This requires a bit more setup: you will need to create bins (ranges of values) and count how many data points fall into each bin using COUNTIFS. Then add both the histogram and the bell curve to the same chart. Many people find this approach clearer for showing how well real data matches a normal distribution.

Troubleshooting common issues

If your curve looks like a flat line, check that you used FALSE (not TRUE) in the NORM.DIST formula. TRUE returns cumulative probability, which produces a different shape entirely. Also confirm that your standard deviation is not extremely large — a standard deviation of 1000 with a mean of 100 will produce an almost invisible curve because the values spread too wide.

If the curve appears jagged instead of smooth, you have too few data points. Go back to column A and use smaller steps (0.5 instead of 1, or 2 instead of 5). More data points create a smoother line. If the curve is cut off at the edges, expand your range in column A to include more values on both sides of the mean.

If you see an error like #NUM! in column B, the most common cause is a negative standard deviation. Standard deviation must be a positive number. Check that you entered the correct value and that it is not referencing a cell with a negative value.

Frequently Asked Questions

What is the difference between NORM.DIST with TRUE and FALSE?

FALSE returns the probability density — the height of the curve at each point, which is what creates the bell shape. TRUE returns the cumulative probability, which produces an S-shaped curve that rises from 0 to 1. For a bell curve, always use FALSE.

Can I create a bell curve without knowing the mean and standard deviation?

You can use any mean and standard deviation you choose, even if they do not match real data. If you have actual data, calculate the mean with =AVERAGE() and standard deviation with =STDEV() or =STDEV.S() for a sample. If you are just showing what a bell curve looks like, use simple numbers like a mean of 100 and standard deviation of 15.

How do I compare two bell curves on the same chart?

Create two sets of data columns — one for each distribution. Use different means or standard deviations in the NORM.DIST formulas. Then add both series to the same chart. Format each curve a different color so they are easy to tell apart.

Why does my bell curve not look symmetrical?

A normal distribution is always symmetrical around the mean. If yours is not, check that your data points in column A are evenly spaced and centered on your mean. For example, if your mean is 100, you should have the same number of points below 100 as above it.

Can I add a shaded area under the bell curve?

Yes, but it requires converting the chart to a different type. Change from XY (Scatter) to Area chart, then format the area under the line with a light color and transparency. This is mostly visual — it does not change the data or the curve itself.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.