Charting Time Samples

  • Thread starter Thread starter Flip
  • Start date Start date
F

Flip

I have a spread sheet with a time value in hours:minutes:seconds in
column A and another on column B with a value in hours:minutes:seconds.
In column C is the difference betwen the two. (=TEXT(B1-A1,"h:mm:ss")
with a results like this....
0:00:48
0:00:48
0:00:48
0:00:48
0:00:50
0:00:48
0:00:50
0:00:52
0:00:52
0:00:57
0:00:58
0:00:58
0:00:58
0:00:58
0:00:58
0:01:00
0:01:00
0:01:00
0:01:00
0:01:00
0:01:00
0:01:00
0:01:02
0:01:02
0:00:04
0:00:04
0:00:04
0:00:04
0:00:06
0:00:06
0:00:06
0:00:06
0:00:06
0:00:06
0:00:06
0:00:25
0:00:25
0:00:25
0:03:25
0:00:27

How do I chart these time samples?
 
Generally charts need an X and a Y value. Are you making a histogram, in
which case X is your time and Y is the number of occurrences of that time?
Or as you say, time is on the Y axis and some mysterious other quantity is
on the X?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top