View Single Post
  #1   Report Post  
 
Posts: n/a
Default Counting datapoints/records in time interval

Hi group,

I have a lot datapoints (y-axis) over time (x-axis).
What I'd need is now something like an aggregation/counting of the kind:
amount of datapoints in all 1 minute intervals plotted as bars/scatter/...
Is there an easy way in excel to acomplish this?
Is programming needed here? If so, has anyone got a pointer for this IMO
standard problem?

Many thanx in advance
edw.