How to Use Excel 2007 to Make a Climograph

1. Open a new worksheet in Excel 2007. Create three column headings: Month, Temperature and Precipitation.
2. Enter 12 rows of data consisting of the 12 months of the year in the first column and the mean monthly temperature and precipitation amounts for each month in the second and third columns, respectively.
3. Click and drag the mouse across your entire range of data in all three columns.
4. Click on the chart button in the toolbar to start the Chart Wizard. Select a clustered column type chart and click 'OK.' You will see the data grouped in two rows of vertical columns.
5. Right-click on the data series marker for temperature and select 'Format Data Series' from the submenu. Select the option for 'Secondary axis' in the pop up window and click 'OK.'
6. Right-click on the data series marker for temperature and select 'Change Series Chart Type' from the submenu. Select a 'Line With Markers' data series type from the pop up window and click 'OK.' You now have a completed climograph.