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

 

[Mike Middleton]

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

 

[MG]

MG -


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