Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Make a bell curve chart
i have a spreadsheet with results of a 5k race, 950 finishers.
i am trying to make a bell curve chart that shows the rate at which finishers come in; i changed the time to a decimal by using the formula "=(C2-INT(C2))*24" that helped, and i now have a valid line chart i trying to show that the majority of finishers are between 8 - 11 minutes, some before and lots after. any ideas on this? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Make a bell curve chart
jackeen -
I suggest that you consider using a histogram, i.e., a column chart of a frequency distribution. (The histogram may or may not have a bell shape, depending on your data.) Here are three approaches: (a) Excel's Analysis ToolPak has a Histogram tool. (b) My free Better Histogram add-in is available at www.treeplan.com. (c) Excel's array-entered FREQUENCY function can create a frequency distribution from which you can construct a Column chart type. - Mike http://www.MikeMiddleton.com "jackeen" wrote in message ... i have a spreadsheet with results of a 5k race, 950 finishers. i am trying to make a bell curve chart that shows the rate at which finishers come in; i changed the time to a decimal by using the formula "=(C2-INT(C2))*24" that helped, and i now have a valid line chart i trying to show that the majority of finishers are between 8 - 11 minutes, some before and lots after. any ideas on this? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Make a bell curve chart
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a normal bell shaped curve in ms 2007? | 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 | |||
How can I make a bell curve in excel? | Excel Discussion (Misc queries) |