Easily create a normal distribution chart (bell curve) in Excel

In Excel, the bell curve chart, is also known as normal distribution chart, is used to analyze the probability of each events. Normally, you can calculate the average, standard deviation and normal distribution by using formulas, and then create the bell curve chart based on the calculated data. Here with Kutools for Excel, you can click to create a standard normal distribution chart by three steps with applying the Normal Distribution / Bell Curve utility.

Create a normal distribution or bell curve chart with several clicks

Create a normal distribution or bell curve chart with several clicks

To create a normal distribution or bell curve chart in Excel quickly, please apply the feature with below steps:

1. Click Kutools > Charts > Data Distribution > Normal Distribution / Bell Curve. See screenshot:

2. In the popped out Quickly create a normal distribution chart dialog, check the chart type that you want to create, and then select the data range that you want to create chart based on, then the max value, min value, average value and standard deviation have been calculated and listed in the dialog. See screenshot:

3. Then, click OK button, the normal distribution or bell curve chart has been created at once, see screenshot:

Tips:

If you check Frequency histogram chart in the Quickly create a normal distribution chart dialog, it will create a histogram chart as below screenshot shown

In the Quickly create a normal distribution chart dialog, if you check both Normal distribution chart and Frequency histogram chart checkboxes, it will create a combo chart as below screenshot shown:

Notes:

1. If you want to output the calculated data, you can check the Output data checkbox, then all calculated data will be output in a new workbook.

2. You can click the Example button in the Quickly create a normal distribution chart dialog box at your first use, and it will create a new workbook to display a sample data and chart for you.