Thursday, May 24, 2018

How do I chart US climate data with Excel?

You can ge the US climate data from this site.


It has data for all the states, like in this image.


USClimateData

This shows the data for Honolulu.


USClimateData_Honolulu

All you need to do is to highlight the data you want to use in Excel as shown,

Copy it.

Paste it into the first cell of an empty sheet.


Once it iss in EXCEL you can use the built-in functionality of charting data.

No comments: