How to Make a Bell Graph in Excel

Creating a bell curve, or a normal distribution graph, in Excel is a powerful way to see how your data is spread out. Whether you’re analyzing sales figures, website traffic, or employee performance reviews, a bell curve can instantly show you what’s typical, what’s an outlier, and how tightly your data clusters around the average. This guide will walk you through the entire process step-by-step, from raw data to a finished, professional chart.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What is a Bell Curve, Anyway?

A bell curve is just a visual representation of a "normal distribution." In a normal distribution, most of the data points cluster around the average (the highest point of the bell) and become less frequent the further they get from the average (the slopes of the bell). It's called a bell curve because, well, it looks like a bell.

Here are the key characteristics of a true normal distribution:

• It's symmetric, with the center line representing the average value. Half the data is on the left, and half is on the right.
• The mean (average), median (middle value), and mode (most frequent value) are all a single point at the center.

In business, you can use a bell curve to analyze almost anything. For example, a marketing team might plot a bell curve of daily website conversions to understand what a "normal" day looks like, helping them spot unusually good or bad days. An HR manager might use one to see how performance review scores are distributed across the company, ensuring a fair and balanced evaluation process.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Get Your Data Ready

First, you need a set of data. A bell curve works best with continuous data, like test scores, product weights, daily sales numbers, or page load times. For this tutorial, we’ll use a simple dataset of 50 customer satisfaction scores, rated on a scale of 1 to 100.

Just put your data into a single column in an Excel sheet. It doesn't need to be sorted. Name the column something descriptive, like "Scores."

Step 2: Calculate the Mean and Standard Deviation

To build our bell curve, we first need to understand the basic statistics of our dataset: the mean (average) and the standard deviation (a measure of how spread out the data is). Excel makes this easy.

Calculate the Mean (Average)

The mean tells you the central point of your data. Pick an empty cell, for example, E2, and type the following formula:

=AVERAGE(A2:A51)

(Be sure to replace A2:A51 with the actual range of your data.)

Calculate the Standard Deviation

The standard deviation tells you how much your data varies from the average. A low standard deviation means your data is clustered tightly around the mean, while a high one means it's more spread out.

In another empty cell, say E3, type this formula:

=STDEV.S(A2:A51)

Again, replace A2:A51 with your data’s cell range. We use STDEV.S because it’s most common to be working with a sample of data, not the entire population.

After you’re done, you should have two cells with your key stats. Label them to keep things organized!

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 3: Create the Range for Your Bell Curve's X-Axis

The smooth line of a bell curve isn't plotted from your actual, individual data points. Instead, it’s drawn using a calculated range of points that spans the full spread of your potential data. A standard practice in statistics is to plot the curve out to three standard deviations on either side of the mean, as this covers about 99.7% of all potential data points.

First, let's establish our boundary data points in a new column. We'll call this column "Data Range."

1. We need a sequence of numbers that will serve as our x-axis values. Let's start with a value 3 standard deviations below the mean. In cell B2, type this formula referencing your mean (E2) and standard deviation (E3):

=$E$2-3*$E$3

1. Now, we need to create a list of data points from our starting point through 3 standard deviations above the mean. The trick is to increase the value in each row by a small, consistent increment to produce a smooth line. A good increment is a fraction of a standard deviation, like 0.25.
2. In cell B3, type the following formula:

=B2+$E$3*0.25

1. Now, click on cell B3, grab the fill handle (the small square in the bottom-right corner), and drag it down until the value is roughly equal to your mean plus three standard deviations (your endpoint can be calculated with =$E$2+3*$E$3). This should give you around 25 data points.

You now have a clean series of values in your "Data Range" column that will serve as the horizontal x-axis for your bell curve.

Step 4: Calculate the Normal Distribution Values

Now we have our x-values (the "Data Range" column), we just need our y-values to plot the curve. This is where Excel’s NORM.DIST function comes in.

The syntax for this function is:

=NORM.DIST(x, mean, standard_dev, cumulative)

• x: The data point you're calculating for (the value in your "Data Range" column).
• mean: The mean of your dataset (the value in cell E2).
• standard_dev: The standard deviation of your dataset (the value in cell E3).
• cumulative: This is important. You MUST set this to FALSE. This tells Excel you want the specific point on the curve (the probability density), not a cumulative total.

Let's do it in a new column called "Normal Distribution."

1. In the top cell of your new column (e.g., C2), type the following formula:

=NORM.DIST(B2,$E$2,$E$3,FALSE)

1. Notice the use of dollar signs ($) for the mean ($E$2) and standard deviation ($E$3). This creates an absolute reference, ensuring that when we drag the formula down, it will always refer to those specific cells, while the reference to B2 will update for each row.
2. Grab the fill handle for cell C2 and drag it down next to your "Data Range" values. You'll see a column of small decimal numbers appear. These are the y-values for your curve!

Step 5: How to Make the Bell Graph in Excel

With our x and y values prepared, creating the chart is the easy part.

1. Highlight both your "Data Range" column and your "Normal Distribution" column, including the headers.
2. Go to the Insert tab on the Ribbon.
3. In the Charts section, find and click on Insert Scatter (X, Y) or Bubble Chart.
4. From the dropdown menu, select Scatter with Smooth Lines.

And that’s it! Excel will instantly generate a bell curve chart. To make it more reader-friendly, be sure to clean it up:

• Change the chart title to something descriptive like "Distribution of Customer Satisfaction Scores."
• Click the "+" icon next to the chart to add Axis Titles. Label the x-axis "Satisfaction Score" and the y-axis "Frequency."
• You can also right-click on the data line to change its color, thickness, or other design elements.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Bonus Tip: Overlay a Histogram of Your Actual Data

A bell curve shows the idealized normal distribution. To make your chart even more powerful, you can overlay a histogram of your actual data. This helps you visually compare your real-world data against the theoretical curve.

Creating a true histogram to perfectly match a secondary axis can be a bit tricky in Excel, but a column chart can serve a very similar purpose and is much easier to set up.

1. Right-click anywhere on your chart and choose Select Data.
2. In the "Select Data Source" window, click Add under "Legend Entries (Series)."
3. For the "Series name," select the header of your original data ("Scores"). For the "Series Y values," select your entire original dataset (A2:A51). Leave the "X values" blank and click OK.
4. You'll notice the bell curve gets distorted. Don't worry, we're fixing that next. Right-click on the new data series (which will likely appear as orange dots or a flat line) and select Change Series Chart Type...
5. In the "Change Chart Type" dialog box, you'll see your two data series. Change the chart type for your original "Scores" series to Clustered Column.
6. Crucially, check the Secondary Axis box for that same "Scores" series. This plots the columns on a different y-axis scale, allowing them to appear visually alongside your bell curve. Click OK.

Now you have a column chart in the background representing your original scores. By right-clicking the columns and selecting "Format Data Series," you can reduce the "Gap Width" to make them look more like a histogram.

Final Thoughts

Building a bell graph in Excel is a straightforward process when broken down into manageable steps. By calculating your core statistics (mean and standard deviation) and thoughtfully setting up your data ranges with the NORM.DIST function, you can create a clear and impactful visual that reveals trends buried inside your data.

While creating charts manually in Excel is a fundamental skill, we know how much time it takes to prepare data, run calculations, and format charts, especially when you need to answer follow-up questions. That's why we built Graphed. We connect directly to your data sources, and you can generate real-time dashboards and reports simply by describing what you want in plain English. This allows you to go from a question to an insight in seconds, giving you back hours to focus on strategy instead of report-building.