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?

What do you want to learn when you look at the chart?

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


Flip wrote:

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?

For every time entry I would like it placed on the Y-axis


Jon Peltier wrote:
What do you want to learn when you look at the chart?

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


Flip wrote:

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/
_______


"Flip" wrote in message
ups.com...
For every time entry I would like it placed on the Y-axis


Jon Peltier wrote:
What do you want to learn when you look at the chart?

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


Flip wrote:

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?