I've been trying to plot a chart in Excel 2007 (on Windows 7).
It's basically some counter vs time-stamp. Now there are holes in the data (e.g. counter is 0 for some period of time, then some values then some 0s). What I want is a complete timeline on x-axis and counter values on y-axis. BY complete I mean if there is a hole in the value I want it visible on chart.
Attached excel contains the original data in col A and B. Col A's timestamps are pretty haywire, it's the raw data. First chart on RHS corresponds to that.
Then I created another set of data out of it, that's in Col D & E. Col D is time incremented by 5 mins (complete timeline without holes in time). Col E is the sum of counter value between D's timestamp and "D's timestamp - 5 mins". Now all I want to do is plot it. That's the second chart.