Remember Me?

#1
January 7th 10, 04:58 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Dec 2009 Posts: 6
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
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
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
January 7th 10, 09:56 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 762
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

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

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

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

All times are GMT +1. The time now is 10:46 PM.