Directions for using Excel to make a nice colorful climograph:
  1. Open Microsoft Excel.
  2. Notice in the Excel matrix columns are marked by different letters; rows by numbers.
  3. Click on the cell at C-3.
  4. Type in “Month” and hit return.  This will be for your own reference only.
  5. 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.
  6. 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 “December.”
  7. Use your mouse or arrow keys to navigate to cell D-3, type in the words “Average Precipitation” and hit return.
  8. 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.
  9. Now enter the average precipitation for each of the months in the cell directly to the right of the specific month.
  10. 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.
  11. Enter the average temperature for each of the months, just like you did for the amounts of precipitation.
  12. 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).
  13. 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.
  14. 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.
  15. Now click on the “Next >” button at the bottom of the screen to move on to Step 2.
  16. 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 Chart Options.
  17. 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.]
  18. You will notice in the display to the right that the title is added.
  19. Under the “Category (X) Axis” enter the word “Months” and hit tab.
  20. Under the “Value (Y) Axis” enter the words “Precipitation in Inches” and hit tab TWICE.
  21. Under the “Second Value (Y) Axis” enter the words “Temperature in Degrees Fahrenheit” and hit tab.
  22. 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.
  23. On the final dialog box click the radio button next to “As new sheet” and hit the “Finish” button.
  24. 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.
  25. 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.
  26. 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.
  27. 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 will remember.