How to create a set of four points, one for each direction, of sky measurements over time?

[Honda_03]

I want to create a plot. A set of four plots (one for each cardinal direction) of my sky measurements over time.

I went out and did field measurements with a temperature infrared gun. I pointed the gun at all four directions in the sky and labeled the time as followed:

time: 10:00am
N: -4.2
E: 10.3
S: 1.2
W: -2.9

time: 10:07
N: -3.6
E: 7.0
S: -0.8
W: -1.9

time: 10:12
N: -4.5
E: 7.4
S: -4.9
W: -1.0

time: 10:29
N: 1.4
E: 7.3
S:
W:

time: 10:36
N: -3.8
E: 6.6
S: 0
W: -2

How would I use excel in order to set of four points for north, west, east, south of these sky measurements/temperatures and plot them over time?


Thank you

[sandy666]

Something like this one?

[Honda_03]

Thanks!
Could you explain how you made this? I don't understand how the chart was made with a x-axis of time and y-axis of temperture.

[sandy666]

You need reorganize your data to the table (as you can see)
then select range, in this case, B2:F7
then choose scatter chart and that's all.

click on chart
select data
edit series to see which serie is selected
edit category to see what was selected


you can change colours, scales, whatever, it's up to you.

If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
If you did it - ignore it.
Thank you.