PREPARING YOUR MAP

Creating your map will be EASY (honest!) if you have your database prepared in the correct manner. Before you start to create your map, make sure you have done the following

  1. Cleaned up your database - All data has been verified
  2. If you located graves not in the original dataset, you have added the information by inserting new rows and using letters to identify them ( ie 6a, 6b, 72a, 83a, 83b).
  3. Added all pace information (see below)

Suggestions for Adding Pace information to your database

  1. Insert four columns to your database- place these right after the grave number (they will become columns C,D,E,F)
  2. Label them as follows:
      • Column C as X feet
      • Column D as Y feet
      • Column E as X pace
      • Column F as Y pace
    • NOTE: It is important that you keep the labels (column B) and the X feet (column C) and Y feet (column D) together. You are going to run a program later that requires these three columns to be next to each other.
  3. Enter your paces in Columns E and F
  4. Calculate the actual distance (in feet) by using the formula function of Excel.
    • Formula will be something like =[X pace distance] * [your pace]
    • Thus if your pace is 4.8ft then you might enter something like the information below into the formula column

 

  • Once you have the formula entered, just place the cursor on the corner dot and drag down the cell column to complete all the conversion information. This process is the same as completing the age at death computation you did for Redtop Cemetery.

OK - Now you are ready to create your map.

Basically the process is exactly the same as creating a chart.

  • First - Highlight the following TWO columns of data : X-Feet, Y Feet. It is important that these TWO columns of data are next to each other and that you highlight all the data in the two columns before you proceed to the next step. It is also vital that the column to the left of the X-feet column is GRAVE NUMBER
    • Confused? Click HERE for an image of the highlighted columns.
  • Click on the Chart Wizard [forgot where this is? It is the icon you clicked on to create histograms]
  • Select X Y Scatter as your Chart type- Chart subtype is the first one on the list - dots only, no lines!- Click NEXT
  • Step 2 of the chart wizard will ask you for the Chart Source Data-
    • Two tabs on on this table - Click on the Series Tab
    • Click on Remove - this just clears all the preset data information
    • Click on ADD - this will put a title "series 1" in the box
    • Next to NAME - type in a title for this chart
    • Click once on X-Values and then go to the spreadsheet and highlight all the cells with X-feet data in them (NOTE: do not included the header information]
    • Click once in the Y-Values box --delete the "junk" in the box first, then go to the spreadsheet and highlight all the cells with Y-Feet data in them.--Click Next
  • Step 3 of the Chart Wizard will show your preliminary plot with lots of information to add
    • Chart Title - the title you added on the previous step should be here - if you want to change it, now is a good time
    • Value X Axis - Probably best to enter DISTANCE IN FEET
    • Value Y Axis - Enter DISTANCE IN FEET
    • leave the other windows open
    • Click NEXT
  • Step 4 - Chart Location
    • Put the chart on a NEW SHEET - It will make it easier to save and print.
    • Click Next

Congratulations! Your "map" is almost finished. Take a look at it. If you want to fix anything, go ahead and do it by clicking on the various pieces and changing them.

I suggest you click on one of the small grave markers - A window should open - on the right side of this window is the "marker" information. Switch the marker style from a diamond to a small dot.

 

OK - now you have only one small task to do to complete this map. You need to add labels to the grave markers.

Directions on adding labels is found in the MACRO section of your instructions (Click on Projects in the webpage header)