## How to graph a Normal Distribution

*Article updated on April 13, 2018*

The chart above is built using the NORM.DIST function and is called **Normal Distribution** or **Bell Curve** chart.

This curve is often used in probability theory and mathematical statistics.

### Instructions

First I'll show you how to construct the data needed, then insert a chart. Lastly, customize the chart to make it look better.

#### Normal distribution data

The chart requires two sets of data, x and y. Enter values from -4, -3.5, -3 ... to 4, they will be x-axis values shown in column B in the picture below.

The NORM.DIST function allows you to calculate the normal distribution for each x value.

Formula in cell C21:

Copy and paste this formula to cells below, as far as needed.

#### Insert a chart

Select the cell range, in my example B21:C37.

Go to tab "Insert" on the ribbon then click on the scatter chart button.

Click on "Scatter with smooth lines" button.

The chart shows up, clearly, we have to do a few changes to this chart.

#### Customize chart

The y-axis values are in the middle of the graph if you want to move it to the left or right follow these steps.

- Right click on x-axis values. (Yes, x-axis.)
- Click on "Format Axis..."
- Find "Vertical axis crosses" setting.

- Select Axis value and type a value. In my example, -6.

Click on major gridlines and press delete button to delete them, if you prefer.

Change the chart title.

### Download Excel *.xlsx file

Use a mouse hovering technique to create an interactive chart

I recently discovered an interesting technique about using a user defined function in a HYPERLINK function. Jordan at the Option […]### Leave a Reply

**How to add a formula to your comment:**

<code>your formula</code>

Remember to convert less than and larger than signs to html character entities before you post your comment.

**How to add VBA code to your comment:**

[vb 1="vbnet" language=","]

VBA code

[/vb]

**How to add a picture to your comment:**

Upload picture to postimage.org

Add picture link to comment.

**Contact Oscar**

You can contact me through this webpage

## Share this article