This should be easy. But it seems impossible in Excel. How do I do it ? My son has had to do the graphs by hand for his school project because Daddy can't sort it.
We've got a series of pressure readings, taken daily, and the corresponding temperatures. Looks kinda like this
a quick look tells us that lower temps seem to be associated with high pressure and high temps with low. We want to graph this, to produce an X-Y scatter chart where X is, say, 990 to 1010 and Y is 0 to 10.
Doesn't look too difficult. But Excel seems to insist on calling the first set of values a series - or something. Anyway, I can't get it to produce this simple graph. What am I missing ? Surely Excel can't be that bad ?
UPDATE - even with the helpful advice in the comments I can't get the beast to work. Doh !