Directions for using
Excel to make a nice colorful climograph:
Open Microsoft Excel.
Notice in the Excel matrix columns are marked
by different letters; rows by numbers.
Click on the cell at C-3.
Type in “Month” and hit return. This
will be for your own reference only.
When you hit return it moves your selected
cell down one. (If you want to move your selected cell one to the
right you can hit a tab or the right cursor.) The cell now highlighted
should be C-4. Type the word “January” and hit return.
Type the word “February” in the next cell
(C-5) and hit return. Enter all of the months, making sure to hit
return after each one. When you are finished, cell C-15 should read
Use your mouse or arrow keys to navigate to
cell D-3, type in the words “Average Precipitation” and hit return.
You will notice that the words do not fit
within the cell. This will not matter when you are making your climograph,
but if you want, you can resize the columns by positioning the mouse arrow
on the line where columns D and E touch. This should transform the
arrow into an icon resembling a plus sign with arrows on the right and
left lines. Left click on the mouse and drag to the right.
This widens the column, allowing “Average Precipitation” to be completely
contained within the cell.
Now enter the average precipitation for each
of the months in the cell directly to the right of the specific month.
When all the amounts have been entered, click
on the cell at E-3 and type “Average Temperature.” You can again
widen the column if you want. Do not use Avg. Min. or Max. temperatures.
Use the Average Monthly Temperatures.
Enter the average temperature for each of
the months, just like you did for the amounts of precipitation.
You now have your completed table entered.
This table will be used to construct your climograph. Click and hold
on the cell at C-3 that reads “months” and drag down and to the right until
the entire table is selected (you should drag to cell E-15).
On the top row of icons to the right, one
that resembles a bar chart. And as you move the mouse cursor over
it, it will show a bubble identifier of Chart Wizard. Click on it.
The Chart Wizard dialog box pops up.
You see that you are in “Step 1 of 4.” Click on the tab near the
top that reads “Custom Types.” Under “Chart Type” scroll down until
you see the “Line – Column on 2 Axes” option and click on it.
Now click on the “Next >” button at the bottom
of the screen to move on to Step 2.
As you can see, the Data Range equals the
sheet you were working on (Sheet1) and the cells you selected ($C$3:$E$15).
All of the defaults in this step are just fine, so click on the “Next >”
button at the bottom. This brings up Step 3, which focuses on different
Under “Chart Title” near the top right type
in “Climograph for <The Name of Your Quad>” and hit the tab key to move
to the next field. [DO NOT hit the return key. If you do you
will be taken to the next step. If this happens by mistake, click
on the “< Back” button to return to the correct dialog box.]
You will notice in the display to the right
that the title is added.
Under the “Category (X) Axis” enter the word
“Months” and hit tab.
Under the “Value (Y) Axis” enter the words
“Precipitation in Inches” and hit tab TWICE.
Under the “Second Value (Y) Axis” enter the
words “Temperature in Degrees Fahrenheit” and hit tab.
Near the top center of the dialog box click
on the tab that reads “Legend.” In the placement box you can decide
where you want your legend to be displayed. Try all of the options
and decide which one you like the most. When you have your choice,
hit the “Next >” button.
On the final dialog box click the radio button
next to “As new sheet” and hit the “Finish” button.
Once your climograph is displayed, most parts
(titles, bars, legend, etc.) can be changed by double clicking on them
to bring up a format dialog box. For example double click on your
title (i.e., “Climograph for …”). The “Format Chart Title” dialog
box appears. You can now change the font, font style, font size,
color, etc. of your title. Experiment until you find something you
like then hit the “OK” button at the bottom of the box. You can see
the changes you made to your title.
It is likely that the precipitation bars and
line for the average temperatures intersect at some points. There
is nothing wrong with this, but if you want them to appear separately (i.e.,
the temperature higher than the inches of precipitation) double click on
the precipitation values on the left Y axis. This brings up the “Format
Axis” dialog box. Click on the tab at the top that reads “Scale.”
By changing the minimum and maximum amounts for each of the Y axis values,
you can cause one series of information (the bars) to appear lower than
the other (the line). To do this, click on the box to the right of
“Maximum” and enter a number that is twice as large as the default.
When you are finished, click the “OK” button at the bottom. This
should make the scale bars half as tall as they originally were.
Hopefully your line will no longer touch the
scale bars. If they are still touching, however, double click on
the right Y axis. Select the “Scale” tab again and change the minimum
temperature to 20 degrees less than it originally was and click the “OK”
button. This should elevate the line higher onto your graph.
Once this has been accomplished you are finished,
but you need to save your work on your network drive or floppy. Click
on File and Save As, changing the drive on the lower right to either your
network drive or the floppy (or zip) and naming your file something you