Make Climograph in Excel  Step by Step Guide ▷ 2020

A climogram is a visual scheme in which the rainfall and temperature values from a specific location. In general, measurements are separated by months during a year. This type of graphic serves to perform comparative analysis in a period of time with climatological variables.

Elaborate this diagram, it can be cumbersome if you use software presentations or text. But nevertheless, use Microsoft Excel to do it, it won’t take more than ten minutes.

For this reason, we present you this post, where you will learn to create your own climate charts and take your analysis to another level.

What should we take into consideration when making a climogram in Excel?

The first thing to keep in mind is that there are certain rules when making one of these charts. Both its form and its content must be meticulously crafted.

As a general rule, it is represented simultaneously the values medium temperature of each month and the corresponding precipitation the same. In the first case, a continuous line, while the second uses vertical bars.

They take the twelve months of each year during a period of 20 or 30 years. (This in a professional job done by climatologists. However, if it is a hobby or hobby, you can take a more limited sample as a practice).

The data you collect must be taken from reliable sources Like the meteorological services nationals or universities. Needless to say that must have the same unit of measure. You can convert online with the google search bar.

The arrangement of the axes must be, by consensus, so that in the horizontal the months of the year, from January to December. While in the verticals (takes two) is located on the right average temperatures on a 5 degree scale.

On the left axis is placed the scale of monthly average rainfall, on a double scale with respect to the previous one, that is, every 10 millimeters. The reason for the difference in measurement between the two vertical axes is that an aridity index can be applied in this way. And so check for a dry season, as well as its duration.

Steps to make a climogram in Excel to keep track of climatological data

The first thing you should do is have the table of measurements you want to analyze. It will have to contain the monthly averages for a specific location.

As an example, we will use the following table that corresponds to the city of Madrid during the year 2012:

Steps to make a climogram in Excel to keep track of weather data example

Once you have the information ready, you just have to follow these steps:

  • Start Microsoft Office in any version.
  • Create a new book in white.
  • Transcribe the data to the table, paying attention not to miss any number.
  • Then, create a new line chart. You will achieve this by pressing the corresponding button in the section “Graphics” found in the tab “Insert”.
  • In doing so I know will create a blank box, you can move it and place it where it is most comfortable for you.

Steps to make a climate chart in Excel to keep track of climatological data Insert chart

  • Now is the time to add information to our blank scheme. To do this, press with the right mouse button about it and choose “Select data”.
  • In this small window, press the button “Add”, a new box will appear, where you will have to place the name of the series. However, it is most convenient to select it from our table. Which in the example is “Medium temperature”. In values, delete the content “= {1}” and replace it by choosing the measurements that correspond to previous item.

Steps to make a climogram in Excel to keep track of climatological data Insert values ​​in the chart

  • Press “To accept”.
  • Perform the same steps, but this time with “Precipitations”. If you make a mistake in these steps, don’t worry, use the button “Modify”.
  • In the column on the right are numbers from 1 to 12, which we must replace by the months. To do this, click on “Edit” and then select them from the first row.
  • Touch “To accept”.

As you can observe, both measurements are expressed in lines. Being that the precipitations must be in vertical bars.

To change this, select the line that corresponds to it (in this case the orange one):

Steps to make a climate graph in Excel to keep track of climatological data change type of graphs

  • Right click and choose “Change type of series chart”.
  • In this menu, tell the program that the series “Precipitations”, must go in “Grouped columns”. To do this, it displays the sub menu which is to the side.
  • Press “To accept”.

As we mentioned before, a climagram must carry two vertical axessince they use two different scales.

By default, Excel associates both series to a single one:

Steps to make a climogram in Excel to keep track of climatological data add axis

  • To change this, press the right button on the mean temperature line and choose “Format data series”.
  • A Side panel, in which you must indicate the latter as “Secondary axis”. Here you can also personalize the colors of the lines and bars If necessary.

Steps to make a climogram in Excel to keep track of climatological data give the axis title

  • Now that we have two different scales, it is precise name the axes. You will achieve it by clicking on the sign “+” that appears in the upper right corner of the schematic and selecting “Axis title”.
  • Change the names and optionally do match the colors that correspond to each type of graph.

Make sure that both vertical axes respect the scales we mentioned before. That is, every 10 mm in rainfall and every 5 degrees in temperature monthly average.

Then follow these steps:

Steps to make a climogram in Excel to keep track of climatological data format the axis

  • To do this, press the right button on one of them and choose “Format axis”.
  • Then in the Side panel, modify the limits and units. Which should be the same in all the climograms you make in the future, to make sense of the study.
  • In the example, we add 5 negative degrees at medium temperature.
  • You can change the size of the weather chart dragging the extreme points of the box.
  • Save your document by pressing “Ctrl + G” or in the tab “Archive”, “Save”.

If you have any questions, leave them in the comments, we will answer you as soon as possible, and it will also be of great help to more members of the community. Thank you! 😉

You may be interested:

Rate this post

Leave a Comment