CODEWITHSUNDEEP
excel
AMM
AMM

Reputation: 17920

how to plot time points in a day on excel

I have a set of points as time of day like 

05:36:37
06:31:41
06:38:24
06:39:42
07:03:47
07:04:18
07:09:28
07:28:40
07:29:20
07:29:49
07:31:57
.....

Now i would like to plot this for an entire 24 hour range in a day.

Basically x axis is the 24 hour range and i need a point for every above time on the y axis. ofcourse y axis may not vary, but i am loooking at finding the coverage as to, in a day, when did the even occur more times. Its the same event. If there are better ways to represent you can also suggest that.

Upvotes: 0

Views: 6030

Answers (1)

Eric Fortis
Eric Fortis

Reputation: 17350

Let's say your data is from A1 to A_N.

in column B enter =HOUR(A1) in column C enter =MINUTE(A1)

Then Insert -> XY Scatter Chart

enter image description here

Upvotes: 1

Related Questions