Makeover Monday – Bee Colony Loss

Makeover Monday – Bee Colony Loss

This week’s #MakeoverMonday challenge is visualizing bee colony loss in the United States.


bee original.PNG
Filled map of 2016/2017 colony losses

I like the filled map and color choices, but was curious about trends over time – which can be difficult to see on a map. Because there aren’t obvious regional trends, a line chart could be more insightful.


bee main


First, get your calculations working.

This slideshow requires JavaScript.

To get the compound losses, I used a calculation from this post by Vijaykumar. Thanks!

Here’s how the third one works:

Bee Calc 4

Once your calculations are setup, create the basic visualization. Then group the outlier states, adjust the formatting, add the boxplot, and add annotations.

This slideshow requires JavaScript.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s