Making Custom Meteograms With Excel

[wxman57]

A few years back, one of my coworkers designed a meteogram spreadsheet in Excel. The graphics have been quite popular here, so I thought I would share the technique and files with everyone. This may also save me from many requests of "make one for my area, please!".

The meteogram spreadsheets below were crafted for the GFS run. However, they can be easily modified to make meteograms from the NAM/ETA or any other model data.

First thing you'll need is a copy of Microsoft Excel, 2007 or later. If necessary, I can create an Excel 2003 version, but you really should update to a modern version of Excel.

Here are the links to the files:

The tutorial takes you through the production step-by-step, with pictures and arrows. The process may look a bit complex, but once you make a few of them you'll find that the whole process takes about 60 seconds.

Tutorial on How to Make the Meteograms:
http://home.comcast.net/~cgh57/meteogra ... aphics.pdf

GFS 0-192hr Meteogram:
http://home.comcast.net/~cgh57/meteograms/GFS.xlsx

GFS 192-384hr Meteogram:
http://home.comcast.net/~cgh57/meteogra ... ended.xlsx

And here's an example I made this morning using the 12Z GFS (0-192hr) GFS for IAH:

[MontgomeryCoWx]

I get hung up at the "raw data" tab in Excel.

I don't see that in my Excel 2007 VERSION. ...