How to Make Charts in Microsoft Excel with DDViewer Tabular Information and Import Them into Microsoft Word

1. Click the "data" radio button at the bottom of the window

note: depending on how many maps you've make, you will see at least 5 columns,
   * the first 4 columns identify the county
   * the remaining column or columns will be identified with a variable name or names
2. Do a left click drag to highlight the columns (include the column headings)
 
1. copy the highlighted area by pressing Ctrl C
3. Make Microsoft Excel the active window
4. Paste the DDViewer info into Microsoft Excel: menu bar/edit/paste (shortcut: Ctrl V)
5. Turn the info into a table: menu bar/data/text to columns
 
1. click "finish" when the pop-up window appears
2. inspect the table carefully

    note: sometimes the data you pasted didn't go to the proper cell or cells (for example, at the bottom of Butler county tables, the Zelienople variable is combined with the area name, so it's necessary to move the value to the variable column)
 
1. remove rows with unnecessary information and empty rows by right-clicking on the row number and clicking "delete"
2. make the column width fit the contents (e.g., the areaname column) by double-clicking on the boundary to the right of the column heading
6. Make charts by sorting your chosen column into ascending order
 
1. left click in any data cell in the column to be sorted
2. Menu bar: data/sort brings up a dialog box and highlights all of your data

* Warning: the shortcut sort button on the toolbar only sorts 1 column at a time and is therefore useless for this exercise; the menu bar sort button allows you to sort multiple columns at a time
 
1. Select the column to be sorted (e.g., "totpop" or "Column B") in the uppermost menu window in the pop-up window
2. click the "ascending" radio button
3. click the "Header row" radio button and click on "OK"
3. make the chart: select a column by clicking on the column letter (this highlights the entire column)
 
1. begin making the chart: menu bar/insert/chart (shortcut: chart icon on standard toolbar)
2. select "line" for a chart type
3. select "line with markers displayed at each data value" for a chart sub-type
4. click the "next" button two times--this will bring you to chart options
 
1. click the "Titles" tab and type in a title that corresponds to a map title
2. click the "Axes" tab and deselect the category or "x" axis--this will remove unnecessary detail
3. click the "Legend" tab and deselect "Show legend"--this will remove the legend
5. click the "finish" button
4. customize the chart
 
1. move the title on to the plot area (i.e., the graph)
7. Export the chart to Word
 
1. reduce the size of the chart
 
1. select the chart
 
1. move the cursor to the blank area around the plot area but inside the neat lines (i.e., the thin black lines on the perimeter of the chart)

note: when you stop the cursor, the little pale yellow pop-up window should say "chart area" (not "plot area")
2. you will have two charts side by side in your document, so each chart should be about half the width of your page
3. reduce the size of the chart by dragging a corner image handle toward the center of the chart
2. copy it: select the chart by by left-clicking in the chart area, then menu bar/edit/copy (shortcut: Ctrl C)
3. make Microsoft Word the active window
4. paste the chart: menu bar/edit/paste
5. crop the neat lines, and continue cropping as close to the edge of the chart as possible
6. reduce the size, and place it beneath the map of that chart's data
8. Here's an example

Created 19 June 97 by Jim Hathaway, last revised 21 November 1999
The original URL for this page is http://www.sru.edu/depts/artsci/ges/hathaway/income/chart_instruct.htm
Last revised 2000.9.10. k.foote@colorado.edu