Note: The other languages of the website are Google-translated. Back to English
English English

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.

Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
  • Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
  • More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
  • Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
  • Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
  • Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
  • Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
  • More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.

Create a bell curve chart and 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, and sort the data by clicking by clicking Data > Sort.
In our case, we enter from 10 to 100 into Rang A2:A92 in the Data Column.

3. Calculate the data as follows:

(1) In Cell C2, please type in below formula to calculate the average:

=AVERAGE(A2:A92)

(2) In Cell D2, please enter below formula to calculate the standard deviation:

=STDEV(A2:A92)

(3) In Cell B2, please type in one of below formulas, and drag the AutoFill Handle to the Range A3:A92.

A. In Excel 2010 or later versions:

=NORM.DIST(A2,$C$2,$D$2,FALSE)

B. In Excel 2007:

=NORMDIST(A2,$C$2,$D$2,FALSE))

Note: The A2:A92 is the range we enter our data, and please change the A2:A92 to the range with your data.

4. 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.

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

5. Save the bell curve chart as a chart template:
A. In Excel 2013 or later versions, 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.

6. 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.

 
 
 
 
 

First-class tool helps you 2 steps to create a bell curve chart in Excel

An amazing Excel add-in, Kutools for Excel, provides 300+ features to help you improve work efficiency greatly. And its Normal Distribution / Bell Curve (chart) feature makes it possible to create a perfect bell curve chart with only 2 steps! Get it now!

Kutools for Excel - Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required! Get It Now


Quickly create a bell curve with an amazing tool

In this method, I will introduce the Normal Distribution / Bell Curve feature of Kutools for Excel. This feature will help you easily create a bell curve chart with only two clicks. In addition, this feature also supports to create a frequency histogram chart, and a combo chart of bell curve and frequency histogram as well.

Kutools for Excel: contains more than 300 handy tools for Excel. Free to try with no limitation in 60 days. Get it now!

1. Select the data range you will create a bell curve based on, and click Kutools > Charts > Normal Distribution / Bell Curve. See screenshot:

2. In the opening dialog, check the Normal distribution chart option in the Select section, and click the OK Button. See screenshot:

Tips:
(1) It’s optional to type in the Chart title in the Chart title box;
(2) If you need to create a frequency histogram chart, please check the Frequency histogram chart option only in the Select section; for a combo chart of bell curve and frequency histogram, please check both options in the Select section.

If you only check the Normal Distribution chart option:

If you check both Normal Distribution chart and Frequency histogram chart options:

 
 
 
 
 

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. Get it now!

Kutools for Excel - Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required! Get It Now

Demo: Create a bell curve chart template in Excel

Kutools for Excel includes more than 300 handy tools for Excel, free to try without limitation in 30 days. Download and Free Trial Now!

Related Articles


The Best Office Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
kte tab 201905

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, 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!
officetab bottom
Comments (32)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
hi thanks for your training article . i performed every thing right as you explained in article . but finally i have an strange graph that is not similar to normal dist . may you help me ? tnx again
This comment was minimized by the moderator on the site
Thanks so much for the training - extremely clear and helpful!
This comment was minimized by the moderator on the site
Very nice way of explaining. It works very fine. I tried for my class marks distribution. Long Live.
This comment was minimized by the moderator on the site
Thank U very much for informative and narrative explanation.
This comment was minimized by the moderator on the site
Thanks, works great for me too, most helpful. Is it possible to overlay two or more distribution curves on the same 'x' axis?
This comment was minimized by the moderator on the site
Thanks for the training. I was wondering if you could add in vertical lines the distance of the standard deviation? Your help is much appreciated -Jordy
This comment was minimized by the moderator on the site
Thanks for the training. I was wondering if it was possible to add vertical lines the distance of the standard deviation from the mean?
This comment was minimized by the moderator on the site
Thank you very much. Most helpful. Please help me to convert this graph in the form of x-axis -4 to +4 with shaded area 68.3,95.4,99.7. , just as it looks like when we search "Normal Curve" in google Thanks
This comment was minimized by the moderator on the site
Thank you very much. How we can decorate this graph with X-axis 0.4 to +4 , mentioning 68,95,97 area
This comment was minimized by the moderator on the site
I just wanted to thank u:)
This comment was minimized by the moderator on the site
Thank you very much. Most helpful.
This comment was minimized by the moderator on the site
Brilliant. Thank you!
This comment was minimized by the moderator on the site
great help
This comment was minimized by the moderator on the site
thanks a lot.
This comment was minimized by the moderator on the site
Is there a way to put a vertical line at a certain Z score? I've been doing it in paint, but I'd like to do it automatically
This comment was minimized by the moderator on the site
Hi Paul,
Thank you for your comment. I am afraid I can’t. Sorry!
This comment was minimized by the moderator on the site
Hi! The way I have done it is by creating an extra set of data and then adding them to the graph. e.g.
y x
0 25
0.1 25

(0.1 is my max distribution and 25 the z score i want to add the vertical line)

Hope it helps :)
This comment was minimized by the moderator on the site
Is there a way to shade parts of this bell curve?
This comment was minimized by the moderator on the site
I would like to plot student scores (percentiles) on a standard bell curve - is that possible to do in excel?
This comment was minimized by the moderator on the site
Hi Brenda,
List the student scores in Column A in the ascending order, and then follow the first method to create a bell curve chart.
This comment was minimized by the moderator on the site
Clear example -- a lifesaver!
This comment was minimized by the moderator on the site
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?
This comment was minimized by the moderator on the site
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.
There are no comments posted here yet
Load More
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations