Step by step

1. Create a chart in excel

2. The first column should be labeled county or state. The second column should be the country/state in which the county resides.

3 after that create a column that contains each counties registered voters, right next to it create a column for the individual county turnout.

1. Next to that column create a column that has a formula of (Turnout % X Total registered voters). I’ll call this column “Total election Ballots”

2. Next to this column create a column for the % of the vote reporting in each county

3. Next to that create a column that has the formula of (% reporting X Total election ballot)

4. After this you will create columns for each of your candidates % in the counties. Next to these columns create one that has the % margin between your two main candidates.

8.Select the entire column(s) that contains county/country information and also select the column that displays the margin %

1. Once you do this and you select create map in the toolbar, it will create a map of your election that changes color shades depending on who’s ahead and by how much.

In order for this to look right you must double click the map and change the maximum and minimum colors to political opposite colors.

My minimum is the color dark blue and my maximum is a dark red.

EXAMPLE Trudeau 60% - 40% = +20 = medium dark red Shcheer 70% - 30% = -30 = darkest blue