Link to home
Start Free TrialLog in
Avatar of theKashyap
theKashyap

asked on

Chart in excel: y-axis not granular enough

Hi Guys,

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.

Thanks
Chart-Problem.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of theKashyap
theKashyap

ASKER

Thank you. Perfect!