View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
MA MA is offline
external usenet poster
 
Posts: 15
Default How can I make an Excel time series chart?

My data is like this:
PersonID Date TimeIn TimeOut
1 1/1/2008 03:18 05:18
2 1/1/2008 11:19 14:21
3 1/3/2008 09:27 15:29

I would like to make a chart that shows how many people were present for
each hour of the day (1 to 24)

Thanks
MA