Cookies help us deliver our services. By using our services, you agree to our use of cookies.
Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to create a bell curve chart template in Excel?

Bell curve chart, named as normal probability distributions in Statistics, is usually made to show the probable events, and the top of the bell curve indicates the most probable event. In this article, I will guide you to create a bell curve chart with your own data, and save the workbook as a template in Excel.

Create a bell curve chart in Excel

Save the bell curve chart as normal chart template in Excel

Save the bell curve chart as AutoText entry in Excel

Easily combine multiple worksheets/workbooks/CSV files into one worksheet/workbook

It may be tedious to combine dozens of sheets from different workbooks into one sheet. But with Kutools for Excel’s Combine (worksheets and workbooks) utility, you can get it done with just several clicks! Full Features 60-day Free Trial!
ad combine sheets books 1


arrow blue right 
bubbleCreate a bell curve chart in Excel, and then save as a chart Template in Excel

To create a bell chart with your own data, and then save it as an Excel template, you can do as following:

1. Create a blank workbook, and enter the column header In Range A1:D1 as following screen shot shows:

2. Enter your data into the Data column. In our case, we enter from 10 to 100 into Rang A2:A92 in Column Data. (Note: if your data are listing randomly, you'd better sort them by clicking Data > Sort.)

3. Calculate the Average and standard deviation.
(1) In Cell C2 enter =AVERAGE(A2:A92), and press the Enter key;
(2) In Cell D2 enter =STDEV(A2:A92), and press the Enter key;
Note: The A2:A92 is the range we enter our data, and please change the A2:A92 to the range with your data.

4. In Cell B2 enter =NORM.DIST(A2,$C$2,$D$2,FALSE) in Excel 2010 and 2013 (in Excel 2007 please enter =NORMDIST(A2,$C$2,$D$2,FALSE)), and drag the Fill Handle to the Range A3:A92.

5. Select the Range A2:B92 (Data column and Distribution column) ,and click the Insert > Scatter ( or Scatter and Doughnut chart in Excel 2013) > Scatter with Smooth Lines and Markers.

Then a bell curve chart is created showing as following screen shot.

You can format the bell curve by removing legends, axis, and gridlines in the bell curve chart.


arrow blue right bubble Save the bell curve chart as normal chart template in Excel

And now you can save the created bell curve chart as a normal chart template in Excel with following steps:

1. Save the bell curve chart as a chart template:
A. In Excel 2013, right click the bell curve chart, and select the Save as Template from the right-clicking menu;
B. In Excel 2007 and 2010, click the bell curve chart to activate the Chart Tools, and then click the Design > Save As Template.

2. In the popping up Save Chart Template dialog box, enter a name for your template in the File name box, and click the Save button.


arrow blue right bubble Save created bell curve chart as AutoText entry for easy reusing with only one click

In addition to saving the created Bell Curve chart as a chart template for reusing in future, Kutools for Excel’s AutoText utility supports Excel users to save created chart as an AutoText entry and reuse the AutoText of chart at any time in any workbook with only one click.

Kutools for Excel - Combines more than 300 Advanced Functions and Tools for Microsoft Excel

1. After creating your Bell Curve chart (how to create a Bell Curve chart?), please activate the AutoText pane with clicking Kutools > Navigation > AutoText button  at far left of Navigation Pane. See left screenshot:

2. Select the Bell Curve chart, and click the Add button  in the AutoText Pane. See screenshot:
doc save bellcurve chart as autotext 1

3. In the Opening New AutoText dialog box, name this new AutoText entry, and specify a group you save this AutoText entry into, and click the Add button.

So far you have saved the Bell Curve chart as an AutoText entry already. From now on, no matter which workbook you are working with, you can click this AutoText entry of Bell Curve chart to insert it in the workbook by only one click at any time. See screenshot:
doc save bellcurve chart as autotext 5

Free Trial Kutools for Excel Now


arrow blue right bubbleDemo: create a bell curve chart and save as AutoText entry (mini template) in Excel

Tip: In this Video, Kutools tab and Enterprise tab are added by Kutools for Excel. If you need it, please click here to have a 60-day free trial without limitation!

Tip: Kutools for Excel's Export Graphics utility can help Excel users quickly export and save all graphics (including pictures, shapes, and charts) as images. And exported graphics can be saved as many formats, such as JPEG, GIF, TIF, or PNG. Full Features 60-day Free Trial!
ad export bell curve chart 1

arrow blue 
right bubbleRelated articles:



Recommended Productivity Tools

Office Tab

gold star1 Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.

Kutools for Excel

gold star1 Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

gold star1 300 New Features for Excel, Make Excel Much Easy and Powerful:

  • Merge Cell/Rows/Columns without Losing Data.
  • Combine and Consolidate Multiple Sheets and Workbooks.
  • Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
  • Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
  • More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...

Screen shot of Kutools for Excel

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Rudra · 24 days ago
    Hi, I have query on NORM.DIST Function in Excel. For probability mass function (False case) contains formula and result is generated. For cumulative (True case) in excel which formula is using to generate the result? For True, it is mentioned as integral of probability mass function formula.
  • To post as a guest, your comment is unpublished.
    DanHammang · 2 months ago
    I think I'm missing something in the instructions for how to make a bell curve chart. In step 4 the formula creates, in cellB2, a normal distribution for the range of my data in column A. However there is no data in B3 through B93, yet the scatter chart seems to require data in cells B3 through B93. How is that data produced? Any suggestions would be appreciated.
    • To post as a guest, your comment is unpublished.
      shawn · 2 months ago
      copy the formula in B2 and paste it in cells B3:B9
  • To post as a guest, your comment is unpublished.
    Jason Erdmann · 8 months ago
    Good stuff, much better than some other site I was trying to follow. But, in Excel 2016 at least, you don't need to sort your data for the graph to show properly, its nice to be able to save a step or not have to worry about it if your data might change, extend, or be in a certain order for a reason (e.g. data entry ease). Also, because you made this so easy to follow, I was able to figure out how to add a second set of data (with its own average, standard deviation, and norm.dist values) to the same graph, it makes my graph more interesting. I think it would be cool if you expanded your base example into an advanced example like that. Again, good stuff.
  • To post as a guest, your comment is unpublished.
    NK · 9 months ago
    Can any set of data be made to look like a Bell curve this way?? What if the Kurtosis of the data was not within +/- 3 for a Normal Distribution?
  • To post as a guest, your comment is unpublished.
    Pam Hanes · 9 months ago
    Clear example -- a lifesaver!