| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I create a historgram of non-discrete events
I am trying to create a histogram of when events occur, but my time values is
associated with a partial event from a Monte Carlo simulation |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I create a historgram of non-discrete events
MG -
I am trying to create a histogram of when events occur, but my time values is associated with a partial event from a Monte Carlo simulation < And what is your problem? Usually a histogram is created using (1) the static Histogram tool of the Analysis ToolPak or (2) the dynamic array-entered FREQUENCY function (or multiple COUNTIF functions) with a Column chart type. A third static alternative is my free Better Histogram add-in available from http://www.treeplan.com. - Mike http://www.mikemiddleton.com |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I create a historgram of non-discrete events
"Mike Middleton" wrote: MG - I am trying to create a histogram of when events occur, but my time values is associated with a partial event from a Monte Carlo simulation < And what is your problem? Usually a histogram is created using (1) the static Histogram tool of the Analysis ToolPak or (2) the dynamic array-entered FREQUENCY function (or multiple COUNTIF functions) with a Column chart type. A third static alternative is my free Better Histogram add-in available from http://www.treeplan.com. - Mike http://www.mikemiddleton.com I want to sum the fractional events that occur within certain time spans the histogram add in will not do it nor will FREQUENCY, though I may beable to use SUMIF |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| quickly create extra copies of a worksheet template in a workbook | Excel Worksheet Functions | |||
| need to create a formula to create a timesheet but haven't a clue | Excel Discussion (Misc queries) | |||
| Create a tabular control | Excel Discussion (Misc queries) | |||
| trying to create | Excel Discussion (Misc queries) | |||
| Use Julian Date To Create Serial Number | Excel Discussion (Misc queries) | |||
Linear Mode
