Thread: How do I create a historgram of non-discrete events
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Mike Middleton Mike Middleton is offline
external usenet poster
  
Posts: 762
Default 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


Reply With QuoteReply With Quote