You can ge the US climate data from this site.
It has data for all the states, like in this image.
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 is in EXCEL you can use the built-in functionality of charting data.
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 is in EXCEL you can use the built-in functionality of charting data.
