#MakeoverMonday 2024 Week 20 - Exporting Freedom, One Bullet at a Time

I struggled mightily with this week's #MakeoverMonday. My goals was to replicate the original visualization by Bloomberg.

I knew I need to create path to connect the US at the center to each country.

I wanted to make the US the center of the of the map.

Sounds simple, right? I made it way harder than it needed to be.

• I overthought the data prep.
• I forgot how to create the paths.
• I couldn't get the math right to offset the longitude.

The coloring and labeling was straightforward for me.

Adding the US as a circle in the middle was pretty simple.

To overcome the problems I faced

• I looked at a previous visualization I created using paths.

• I opened the workbook and the data to see the configuration.
• I replicated that set up by adding a second set of records to the data set.
• Viewers on the livestream helped me figure out the math to offset the longitude.

The simplest way to explain the location of each country is to think of the lat/lon for the US as 0,0. Then you compare that to the lat/lon for every other country to create the offset.

I got there in the end. What do you think? Was the juice worth the squeeze?

Click the image below to access the viz.