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
- Cleaned up your database - All data has been verified
- 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).
- Added all pace information (see below)
Suggestions for Adding Pace information to your database
- Insert four columns to your database- place these right after the
grave number (they will become columns C,D,E,F)
- Label them as follows:
- Column C as X feet
- Column D as Y feet
- Column E as X pace
- Column F as Y pace
Enter your paces in Columns E and F
Calculate the actual distance (in feet) by using the formula function
- 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.
- 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
- 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
- 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)