I'm interested in creating one or more spreadsheet graphs of interval metered data. The raw data is recorded as a continuously increasing value (i.e. total bytes, user logins, website hits) and date. Each sample measurement date will happen at a non-constant interval. For simplicity I would like to record the data in a spreadsheet program, such as OpenOffice Calc.
An example of the data:
Date/Time Value
1/1/09 12:00 PM 10
1/1/09 5:00 PM 30
1/2/09 9:00 AM 100
1/2/09 6:00 PM 150
Ideally, I want to have a single chart to graph the rate of the data, and would have the following features:
- Dynamic selection of graph date ranges as new data is gather. (N days to N years)
- Dynamic granularity of data rate display. (per hour, per day, per month, per year)
- Extra credit, enable a secondary plot of data to overlay the first plot.
Please comment on how feasible this is, and what techniques and features I can use to accomplish this in either Excel or preferably OpenOffice Calc.