How to Create a Professional Dynamic Dashboard for the US Presidential Elections 2020 and 2024?

❌ No macros required, no Add-ins, no external connections, and no other advanced features such as Power BI, QUERY, or PIVOT— not even fancy Dynamic Array Formulas. However, you must have access to MS Excel.

All You Need:

1. Data Source: Includes the results of the 2020 and 2024 presidential elections for each state.
2. INDEX and MATCH Functions: Create an additional column to show the winner based on Year selected in Data Validation.

=INDEX(F2,MATCH(Year,$F$1:$H$1,0))

3. Data Validation: Select the Year of the election (2020,2024,2020-24).

4. Cartogram 51 Cells: Representing all states plus the District of Columbia.

5. Condition Formatting: Based on Year Selection and winner by state. Applies to 51 Cells range.

For example, if Republican Trump won in a relevant state, use the following formula to determine which cells to format:

=LOOKUP(C3,Data!$B$2:$I$52)="Trump"

Format fill with Orange and so on.

Note: Democrat Flip is not applicable for this case.

This is the basic version. However, if you require an advanced version, please send me a message by clicking the button below.

Tags: 2024, cartogram, dashboard, election, heatmap, President, USA, USelection2024