View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
mjwedeking mjwedeking is offline
external usenet poster
 
Posts: 5
Default Plot Hourly Data

How can you plot data that is less than daily? I typically create charts of
data that has hourly or even 15 minute time steps. Excel will sum all the
values for the day and just plot daily data, or monthly, or yearly.

Sample Data:
A B C
Date Time Flow(mgd) Rain(in)
2/13/2007 1:00 1.2 0
2/13/2007 2:00 1.3 0.1
2/13/2007 3:00 1.5 0.2
2/13/2007 4:00 1.1 0