# How Do I create a (Pretty) Bell Curve in Excel 2010

#### UrbanJungleFashion

##### New Member
Hey guys. I have been having the worse time figuring this out. I am trying to create an attractive bell curve in Excel. My boss has put a lot of pressure on me but I just can't seem to do this.

I am trying to create a bell curve based on total sqft of a store.

Here is an example the data. In reality I have over 1000 stories. I used the formula STDEV.P because I do have our entire population. However, my bell curves don't look like bells.... they look like drunk mole hills. Can someone please help?

Here is an example of the data and my math:

Am I just understanding SD incorrectly? Does it always have to be between -3 and 3? I am just sick and I have to figure this out in 7 hours!!!

 STORE # \$ per RSF Distribution Mean SD 0001 7.29 0.009876 31.23 28.10553 0002 10.83 0.010908 0003 17.36 0.012567 0004 18.21 0.01275 0005 18.96 0.012904 0006 22.28 0.013493 0007 22.38 0.013507 0008 25.23 0.013875 0009 28.63 0.014134 0010 64.41 0.007072 0011 107.95 0.000342

<tbody>
</tbody>

<tbody>
</tbody>

### Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

#### AhoyNC

##### Well-known Member

In a normal distribution about 99.7% of the values will be between -3 & 3 SD from the mean, but no all values do not have to be between -3 & 3.