Easily create a normal distribution chart (bell curve) in Excel
Kutools for Excel
Boosts Excel With 300+
Powerful Features
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.
Productivity Tools Recommended
Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs — no more cluttered windows. Know more...
Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010–2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...
Kutools for Excel
Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 – 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.
