#1   Report Post  
Old January 7th 10, 04:58 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2009
Posts: 6
Default Bell Curve Chart

I have 2 columns of data - see below. My boss wants me to create a bell
curve chart, but if I use the chart wizard and select "Line" from the
Standard Types tab then my chart has steep angles. I reviewed Article 213930
"How To Create A Bell Curve Chart" - 4 pages of complicated how to's and got
hung up on the first page. Can anyone provide me with some easy to follow
instructions?

A-1 11
A-2 16
A-3 23
B-1 60
B-2 32
B-3 18
C-1 9
C-2 4
C-3 2


  #2   Report Post  
Old January 7th 10, 06:29 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 5,441
Default Bell Curve Chart

Try using an XY chart with smoothed lines.

As for creating a Bell Curve Chart - those are the simplest instructions.

HTH,
Bernie
MS Excel MVP


"perale" wrote in message
...
I have 2 columns of data - see below. My boss wants me to create a bell
curve chart, but if I use the chart wizard and select "Line" from the
Standard Types tab then my chart has steep angles. I reviewed Article 213930
"How To Create A Bell Curve Chart" - 4 pages of complicated how to's and got
hung up on the first page. Can anyone provide me with some easy to follow
instructions?

A-1 11
A-2 16
A-3 23
B-1 60
B-2 32
B-3 18
C-1 9
C-2 4
C-3 2



  #3   Report Post  
Old January 7th 10, 09:56 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 762
Default Bell Curve Chart

perale -

The phrase "bell curve" usually refers to the very special Gaussian
("normal") probability density function.

In many situations, a "histogram" is a better first step in describing your
data.

An Excel histogram is a Column chart type for a frequency distribution of
your data.

If you want to create a histogram, you can use Excel's Histogram tool, part
of the Excel's Analysis ToolPak add-in. Or, you can use my free Better
Histogram tool, available from www.treeplan.com. Or, you can use Excel's
FREQUENCY array-entered worksheet function and create a Column chart from
the function results.

- Mike
http://www.MikeMiddleton.com



"perale" wrote in message
...
I have 2 columns of data - see below. My boss wants me to create a bell
curve chart, but if I use the chart wizard and select "Line" from the
Standard Types tab then my chart has steep angles. I reviewed Article
213930
"How To Create A Bell Curve Chart" - 4 pages of complicated how to's and got
hung up on the first page. Can anyone provide me with some easy to follow
instructions?

A-1 11
A-2 16
A-3 23
B-1 60
B-2 32
B-3 18
C-1 9
C-2 4
C-3 2



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bell Curve RLind Excel Worksheet Functions 6 February 22nd 13 12:49 AM
Make a bell curve chart jackeen Charts and Charting in Excel 2 December 6th 09 12:35 AM
Creating a bell curve chart [email protected] Charts and Charting in Excel 1 May 15th 08 10:43 PM
Bell Curve Todd Nelson Excel Discussion (Misc queries) 3 December 7th 07 01:36 PM
Creating Bell Curve Chart MikeR-Oz Charts and Charting in Excel 3 February 2nd 06 12:19 PM


All times are GMT +1. The time now is 06:20 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017