In this Article we will learn about the creation of Bell curve in Excel.

Let us prepare a blank Excel file with the data. We need Distribution, Average and Standard Deviation values.


Now we will add the formulas for the Distribution, average and standard deviation.

Distribution: =NORM.DIST(A2,$C$2,$D$2,FALSE)

Average: =AVERAGE(A2:A52)

Standard deviation: =STDEV(A2:A52)


Now let's plot the scatter with smooth lines and markers chart for the same:

Scatter With Smooth Lines


We got the perfect example of a bell curve as the result:

Bell Curve Excel chart

 Please find attached the Excel file for reference.