...

1. Add formatted Excel spreadsheet
2. In the Contents pane, right-click the LotsWithIDs layer and select Joins and Relates > Add Join.
3. For 'Layer Name or Table View' keep Lots with id
4. For 'Input Join Field', scroll down to the very bottom and select TxtMemo
5. For 'Join Table', select outside Excel table
6. For 'Output Join Field', Select Lot, exact name is in Google spreadsheet.
7. In the Contents pane, right-click the LotsWithIDs layer and select Attribute Table. Scroll to the right and ensure that your variables are appearing okay.
8. (Can repeat the join process with multiple tables to create a single mega-table)

SYMBOLOGY

Sample Variables Used in Training

1. Variables: Total sherds
2. Total sherds for each time period, pick 2 that contrast well for demo
3. Decorated in one period, normalized by total in one period to symbolize percent decorated in that period

Basic Symbology with Graduated Colors

...

1. In the Symbology pane, for 'Normalization', select the population universe field, if a percentage is desired.
2. At the top of the Symbology pane, click the Advanced symbol options button (4th button with paintbrush).
3. Expand the Format labels section.
4. For 'Category', used the drop-down menu to select Percentage.
5. Change radio button to For 'Percentage', select Number represents a fraction if you ., assuming your values are between 0 and 1.
6. For decimal 'Decimal places, pick something like 0 or 1', you will likely want to type "0" or "1".

Duplicating Layers for Different Symbology

1. In the Contents pane, right-click the LotsWithID layer name and select Copy.
2. Scroll to the top of the Contents pane and right-click the name of the map (e.g. Map) and select Paste. This can be repeated for as many fields (variables) as you'd like to symbolize within that particular layer's attribute table.
3. Create 3 copies for 4 total (Chirqui Decorated/Chiriqui sherds) (Total quebradas vs total chiriqui)

If you have more than a few variable layers, you will likely want to organize them by topic using group layers.

1. At the top of the Contents pane, right-click on Map and selectNew Group Layer.
2. Drag and drop the related layers on top of the group layer.

Additional Symbology Options with Graduated Colors

1. For 'Methods', preview Natural Breaks and Quantile at a minimum, referring to both the table and the histogram and think about the impacts on the appearance of the map.
2. After your examination, you will likely want to round the values to facilitate quick interpretation (unless exact statistical breaks, such as quantile are required for another reason.) (In the demo, we rounded to 5/10/25/100 for Total Sherds)
3. For 'Classes', we recommend reducing the number to 3 or 4, if possible, and no more than 5, unless you spend time customizing the colors to ensure the can be easily distinguished on the map.
4. Color ramps, format color scheme and triangle button to flip ramp, show adjusting individual colors in the ramp
5. For 'Color scheme', use the drop-down menu to select the color ramp of your choice.
6. To customize the color scheme, use the drop-down menu to select Format color scheme....
7. Click the triangle-shaped Reverse color scheme button to flip ramp.
8. To adjust the colors used in a Continuous Color Scheme, click on one of the Stop color sliders and then use the Color drop-down menu below to select the desired color.
9. To customize the polygon borders, in In the Symbology pane, at the top-right of the Symbol table, click More and select format all symbols, properties tab, change outline color and/or widthFor full zoom . For a map fully zoomed out, you will likely might want to completely remove borders
10. In Contents pane, copy lots with id layer and right-click Map at top of Contents pane and paste, do 3 copies for 4 total (Chirqui Decorated/Chiriqui sherds) (Total quebradas vs total chiriqui)
11. The symbology pane applies to whichever layer is selected in the Contents pane,the borders or the borders will completely obscure the fill colors of the polygon.

LAYOUTS

Full page appendix maps

...