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 Feature Free Trial 60-day!
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

Kutools for Excel - Includes more than 300 handy Excel tools. Full feature free trial 60-day, no credit card required! Get it now!


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

In this Video, the Kutools tab and the Kutools Plus tab are added by Kutools for Excel. If 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 Feature Free Trial 60-day!
ad export bell curve chart 1

arrow blue 
right bubbleRelated articles:



Recommended Productivity Tools for Excel

Kutools for Excel Helps You Always Finish Work Ahead of Time, and Stand Out From Crowd

  • More than 300 powerful advanced features, designed for 1500 work scenarios, increasing productivity by 70%, give you more time to take care of family and enjoy life.
  • No longer need memorizing formulas and VBA codes, give your brain a rest from now on.
  • Become an Excel expert in 3 minutes, Complicated and repeated operations can be done in seconds, 
  • Reduce thousands of keyboard & mouse operations every day, say goodbye to occupational diseases now.
  • 110,000 highly effective people and 300+ world-renowned companies' choice.
  • 60-day full features free trial. 60-day money back guarantees. 2 years of free upgrade and support.

Brings Tabbed Browsing and Editing to Microsoft Office, Far More Powerful Than The Browser's Tabs

  • Office Tab is designed for Word, Excel, PowerPoint and Other Office Applications: Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
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.
    Sophie · 2 months ago
    I followed the instructions above but ended up with a graph which wasn't in a normal distribution. What can I do to make this normally distributed?
  • To post as a guest, your comment is unpublished.
    Geeky · 2 months ago
    Good explanation loved it!
  • To post as a guest, your comment is unpublished.
    Rudra · 6 months 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 · 8 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 · 7 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 · 1 years 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.