Cartography: Graphic Exercise
Go to the class homepage and click on the Project 12--Graphs link.
Use that connection to download the .xls file of data for this exercise that is located at
These data are from the sources indicated and will provide you with the base data
needed for making the first three graphs. These graphs are:
- climograph of Anniston--(source of US city data: http://www.cdc.noaa.gov/~cas/Climo/polys/alabama.html, examine monthly rankings for temperature and precipitation
- population pyramid for Alabama--(source of data: http://www.census.gov/population/estimates/state/s5yr8090.txt)
- sector graph or pie graph--(source of possible data: http://www.census.gov/population/pop-profile/1999/chap05.pdf or http://www.census.gov/population/pop-profile/1999/chap07.pdf or http://www.census.gov/population/pop-profile/1999/chap08.pdf or http://www.census.gov/population/pop-profile/1999/chap03.pdf)
The fourth graph is a topographic profile from the Hilton, VA 1:24,000 topographic quadrangle used in Map Reading.
First Graph: Climograph
A climograph shows the mean monthly temperatures for a station as a line graph and the total monthly precipitation in a bar graph.
- Highlight the entire climate section of the spreadsheet, copy it, and paste it into a new spreadsheet.
- Cut the temperature row from this new spreadsheet and paste that row below the precipitation row.
- Edit the spreadsheet so that the months are just above the precipitation which is just above the temperatures. Delete any extra blank rows.
- Highlight the three rows of climate data to be graphed in the Excel spreadsheet. The summary data is not graphed.
- Click the graph icon on the toolbar to activate the chart wizard.
- Choose Custom Types, Line-Column on 2 axes. Then click Next.
- If you correctly highlighted the three rows, the data range should be correct. The series in: rows should also be correct. Click next.
- Give the chart an appropriate title.
- Label the Value (y) axis.
- Label the Second Value (y) axis.
- Remove the legend.
- Enter it as a new sheet in the workbook.
- Point to a bar on the graph and double click on it.
- Choose the options tab and adjust the gap width.
- You may customize the patterns and colors.
- Click on the left y axis.
- Set the maximum at 25.
- Click on the right y axis.
- Set the maximum at 100.
- Drag the plot area to produce an appropriate width.
- Make any other changes to produce a professional climograph.
- Copy it.
- Paste it into PowerPoint.
- Crop and edit as desired.
- Save as a .jpg file.
- Create the files necessary to connect it to your homepage.
Second Graph: Population Pyramid
A population pyramid shows the age and sex distribution of the population with the males on the left side and the females on the right side. The age groups are called cohorts.
- Examine the set of population data.
- Decide which data set you want to map.
- Copy the male data you select to Column B of a new spreadsheet.
- Copy the female data to Column C of a new spreadsheet.
- Copy the cohort descriptions to Column A of a new spreadsheet.
- Be sure that the data line up correctly.
- Label the columns males and females.
- Edit the males values to NEGATIVE by inserting a -before each value.
- Highlight the three columns of data.
- Click on the graph icon to activate the chart wizard.
- Choose Custom Types.
- Choose Tubes, then Next.
- The data range and series should be correct, so select Next.
- Give the chart an appropriate title.
- Use the Value Y axis to label Males (spaces) Females.
- Turn off the legend.
- Turn off the data labels.
- Make any other changes, such as add and edit a vertical grid.
- Enter as a chart on a new spreadsheet and Finish.
- Double click on the bars to edit them.
- Change the gap width to 0 and leave the overlap 100.
- Click on the x axis and adjust it appropriately.
- Change the size of the plot area.
- Copy and paste the graph into PowerPoint.
- Complete your editing to produce a professional population pyramid.
- Save it as a .jpg.
- Prepare the pages for web posting and link the graph to your homepage.
Third Graph: Pie Chart
A pie chart or sector graph depicts the percentage of subdivisions of a whole.
The spreadsheet provides a variety of data that may be appropriate for this type of graph. Check your textbook for additional details.
Using a subset of the data provided, produce a professional quality pie graph.
Use Excel to make the basic graph and finish your edits in Powerpoint.
Save it as a .jpg, produce the necessary html pages, and connect your graph to your homepage.
Fourth Graph: Topographic Profile with Excel
Using your Hilton, VA topographic map 1:24,000 from Map Reading, draw a topographic profile from the new building just south of the poor motor road southeast from Otter House Bluff and south of the O in Fork of the words North Fork Holston River. The location is 36° 38' 25"N, 82° 26' 57"W. End the profile at New Bethel Church at 36° 41' 13"N, 82° 27' 56"W. Follow the instructions below.
- Lay the EDGE of a piece of wide ruled (not college ruled) notebook paper, between the starting and ending locations.
- Place the building (not the church) at one of the ruled lines on the paper.
- Secure the paper in place between the two points.
- On another sheet, record in order from building to church the elevation of each point where a notebook ruled line intersects the transect between the points. Be as exact as you can, interpolating values when the points do not fall on a contour line.
- End with the notebook line just on past the church.
- Enter these values in order in a column in Excel.
- Use the custom type graph called smooth line to graph these elevations.
- Adjust the vertical exaggeration to suitably show the asymmetric ridges and the geologic dip direction.
- Label the y-axis.
- Calculate and state the horizontal scale in feet between the un-labeled data locations.
- Indicate the orientation of the graph.
- Add appropriate locational labels to the graph.
- Add all necessary map elements.
Remember that all of these pages should contain all of the required elements, such as your name, source of data, dates, etc.
Be sure to check the grading sheets.