Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bell Curve | Excel Worksheet Functions | |||
Make a bell curve chart | Charts and Charting in Excel | |||
Creating a bell curve chart | Charts and Charting in Excel | |||
Bell Curve | Excel Discussion (Misc queries) | |||
Creating Bell Curve Chart | Charts and Charting in Excel |