Showing Change with a Scatterplot in Tableau

Recently the VizWiz blog had a post showing how to create a 45-degree reference/trend line in a scatterplot. The original purpose was comparing countries based on literacy rates for females and males. Those above the line were countries where females had higher literacy rates and below were countries where males had the higher literacy rate. From there the post went on to talk about change in a couple of other datasets. But, there was an issue in producing the correct color coding to represent the change from year to year in those other datasets. This got me thinking that I wanted to see if I could figure out why the color coding of change wasn’t working as expected in those examples. (NOTE: Description of how to get the 45-degree line and fix the issue he encountered are at the end of this post.) Of course, trying to tie things to higher education, I decided to use my standby of accountability data from the Texas Higher Education Coordinating Board (THECB) which I’ve used previously.
Continue reading Showing Change with a Scatterplot in Tableau