The guide is based on kingsoft spreadsheets, but microsoft office is basically the same. You can use any spreadsheet software as long as it provides
the same options.
Open a new table.
Copy the data from your source. GISS station viewer, data
Paste the data into the upper left cell (A 1).
Go to ‘data’ and click ‘text to columns’.
In the window that pops up, select ‘fixed width’ and then ‘next’ to see if the columns are correctly separated. The dates should be in the
left column and each month of data in a separate column. Most of the time it works by default and you can just hit ‘finish’.
Delete any missing data entries (usually -999.9).
To plot a (month, season, year), click the header of the column with the dates first. It will highlight/select the whole column. Then hold down
control on your keyboard and click the headers of the columns you want to plot.
Go to ‘insert’ and click ‘chart’. Select ‘X Y (Scatter)’ and then any of the ‘line’ charts in the top.
You can customize the chart the way you like. To resize it just click on an empty space in the chart and drag the corners. To open the menus for the
chart elements (x -y axis, data series ect.) right-click on the element and select ‘format (...)’.
If you want to change the range of the y and x axis, just navigate to ‘axis’, then ‘axis options’ and type in the dates or temp. range.
(format menu should pop up to the right)
Right-click on the data in the chart and select ‘add trendline’, the default trend will be linear (the trend you need to determine the rate of
change for any period).
Navigate to ‘trendline’ in the the ‘format trend’ tab and select ‘display equation on chart’. Since most of your dates will be
‘years’, just multiply the value between ‘y = 0.0(some number)x’ by 10 for the trend per decade or 100 for the century.
You can also add a polynomial fit as visual aid. You can change the ‘degree’ of the fit by changing the value to the right (default 2, max 6). In
most cases, 4th is the least sensitive to end points and still represent the ‘behavior’ of the data realistically.
There is probably some things i forgot to mention, if you run into any issues, just ask and i try respond as quick as possible.
Go to ‘Monthly station data’.
Type in the name of a station or select a region on the ‘world map’ (coordinates will show up in the boxes), then select the type of data you want
(mean, max, min) and click ‘Get Stations’
In the list of stations, click on ‘get data’ to bring up the page for the station. Then click on ‘raw data’ above the top chart. (for
anomalies click ‘raw data’ above the bottom chart)
You can now copy the data for your spreadsheet (same as the GISS station viewer).
If anything is unclear, feel free to ask.