Create a Bell Curve Graph

To create a Bell Curve / Normal Distribution graph,

1) First we need to calculate the x-axis and y-axis.

2) For x-axis, Range is from Mean-3*SD to Mean+3*SD.(Data1 (E:E), Data2 (U:U) )
In our Example, Mean-3*SD is -78.89. So E2 = -78.89, E3=E2+1 E4=E3+1...so on . Add 1 till it reaches to Mean+3*SD i.e 152.89

3) And For y-axis , use formula =NORMDIST($E$2:$E$233,$C$2,$C$3,FALSE) in F column for Data1 , or
=NORMDIST($U$2:$U$152,$T$2,$T$3,FALSE) in V column for Data2.
syntax: =NORMDIST(x, mean, standard_dev; cumulative)

So, we have created 2 column for each data set. E2:F233 for Data1; U2:V152 for Data2.

4) Select E2:F233. Click on Insert tab >> Select scatter graph (scatter with smooth line). And here, we are done with Bell Graph for Data1.
Similary, Select U2:V152. Click on Insert tab >> Select scatter (scatter with smooth line) for Data2.

Optional, to overlap graph into one another . Click on Data2 graph. Press Ctrl+X to cut the data, then Select the Data1 graph and press Ctrl+V to paste into it.

Thank You!!