DS7 Tip Week - Creating a bump chart

by George Walker

In my last blog I cleaned up the data that we are going to use for my bump chart – now I’ll take you through how to make it.

First lets create our initial view

This creates a nice initial graph of population over time – now we want to transform this into a bump chart

We need to create a table calculation to give us the rank (which is how we plot a bump chart). If you check out Joe’s blog on the language of table calcs you will quickly work that “for each year we want to calculate the rank by state” this translates to the below settings

I’ve reversed the axis and now we have a bump chart that matches the basics of the Vox graph. In my next blog I’ll take you through the final formatting.

 

 

Dashboard Week Day 4 - CHEESE

2 mins read

Thu 14 Dec 2017

Dashboard Week Day 3 - Data School Blog Google Analytics

1 mins read

Thu 14 Dec 2017

Dashboard Week Day 2 - Romantic partner preferences

1 mins read

Wed 13 Dec 2017

Dashboard Week Day 1 - Proper Planning Prevents Piss Poor Performance

2 mins read

Tue 12 Dec 2017