View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
smartin smartin is offline
external usenet poster
 
Posts: 915
Default Need help with a chart in Excel

NEHicks wrote:
I have an excel database that has entries by date with a time associated with
each entry. I need to create a monthly line chart that shows the number of
incidents in a time range, i.e. 0000-0159, 0200-0359, 1200-1359, etc.

What the chart will show will be the time range where the most entries are
made.

I am at a loss as to how to start.

Thanks,


The FREQUENCY function is made-to-order for obtaining such
distributions. To use it you will have to create a little infrastructure
first, like creating the time "buckets" you want to tally (see F1 on
FREQUENCY), and probably converting decimal times to human-readable form.