It looks like you're using an Ad Blocker.

Please white-list or disable in your ad-blocking tool.

Thank you.


Some features of ATS will be disabled while you continue to use an ad-blocker.


Climate lit. how to plot charts

page: 1

log in


posted on Mar, 21 2019 @ 07:24 AM

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 example

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.

Climate Explorer Quick guide:

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.

posted on Mar, 21 2019 @ 08:05 AM
Are these temperature recordings before or after the NOAA/NASA makes their modifications to the data?

posted on Mar, 21 2019 @ 08:22 AM
a reply to: jjkenobi


Both, the climate explorer and giss surface stations also provide the raw data. It's important to understand why adjustments to the data are necessary, but it's not totally arcane.

US data is generally the most 'mature'. (the data doesn't change periodically)

The are only a few regions where periodic adjustments make impossible or very difficult to figure out how temperatures have changed.

If you like join the main thread and we can try it for a place of your choice.

new topics

log in