Chart of Times

[Jim]

I am working with a simple data set comprised of two columns and 24
rows.

In column ("A"), I have the numbers 1-24. In column B, I have these
random times:

4:57
5:16
2:17
1:20
1:11
1:21
1:19
1:11
1:37
2:56
3:29
4:09
5:59
5:23
5:22
3:59
4:04
1:51
2:06
2:16
2:08
1:28
1:24
1:24

The chart I would like to make would have the numbers 1-24 on the X-
axis and the times listed above on the Y-axis. Ideally, this would be
a column chart.

My Issue:
The times listed in column ("B") are formatted as time. When the
chart is created the X-axis and Y-axis are both correctly labeled, but
all of the data points are coming up 12:00 AM. Any idea what the
problem/fix is?

Thanks,

Jim

 

[Bernard Liengme]

I cannot reproduce this. I enters 1,2,...24 in A1:A24 and copied your data
to B1:B24. Made a column chart and all looks fine.
Want to send me a file? Get my email addy from my website
best wishes

 

[Gord Dibben]

Your numbers may be formatted as Time but they are still Text.

Select all and Data>Text to Columns>Next>Next>General>Finish

You will probably get away with simply Data>Text to Columns>Finish but I
like to make sure that General is defaulted.


Gord Dibben MS Excel MVP

 

[Jim]

Bernard,

Thanks for the help. The reason you could not reproduce the issue was
a result of the formatting. The times all came from a database and
the default formatting was not compatible. I used the TIMEVALUE
function to correct and it worked. Thanks,

Jim