Table of Contents
Creating a Bell Curve in Excel is a simple and effective way to visualize data distribution. This can be done by plotting a normal distribution curve over a histogram of the data. To begin, select the data set you want to graph and insert a histogram chart. Then, add a normal distribution curve by selecting the chart and going to the “Design” tab, clicking “Add Chart Element” and choosing “Trendline” and then “More Trendline Options.” In the “Format Trendline” window, select “Normal Distribution” as the trendline type. This will create a bell curve over the histogram, representing the data’s distribution. A template for creating a Bell Curve in Excel can be found online, or by using the above steps to create a basic template. This can be customized to fit your specific data and design needs.
Make a Bell Curve in Excel: Example + Template
A “bell curve” is the nickname given to the shape of a normal distribution, which has a distinct “bell” shape:
This tutorial explains how to make a bell curve in Excel for a given mean and standard deviation and even provides a free downloadable template that you can use to make your own bell curve in Excel.
Example: Bell Curve in Excel
Use the following steps to make a bell curve in Excel.
Step 1: Create cells for the mean and standard deviation.
Step 2: Create cells for percentiles from -4 to 4, in increments of 0.1.
. . .
Step 3: Create a column of data values to be used in the graph.
Step 4: Find the values for the normal distribution pdf.
Step 5: Create x-axis plot labels for only the integer percentiles.
First, highlight all of the values in the pdf column:
Then, in the Charts group on the Insert tab, click the first plot option in the Insert Line or Area Chart category:
A bell curve will automatically appear:
Step 7: Modify the x-axis labels.
Right click anywhere on the chart and click Select Data. A new window will pop up. Click on the Edit button under Horizontal Axis Labels:
Select the range of cells where the x-axis labels are located. In our case, it’s cell range D5:D85. Then click OK.
The x-axis labels will update automatically :
You’ll notice that if you change the mean and standard deviation, the bell curve will update automatically. For example, here’s what the bell curve turns into if we use mean = 10 and standard deviation = 2:
Feel free to modify the chart title, add axis labels, and change the color if you’d like to make the chart more aesthetically pleasing.
Free Template
Feel free to download this free template that was used to make the exact bell curve in this tutorial.
Additional Resources
An Introduction to the Normal Distribution
Normal CDF Calculator
How to Plot a Normal Distribution in R