ExcelBanter - Charting Time Samples

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Charting Time Samples (https://www.excelbanter.com/charts-charting-excel/55630-charting-time-samples.html)

Charting Time Samples

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?

Charting 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?

Charting 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?

Charting 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?