Makeover Monday 2019 Week 13: Consumer Spending by Generation

Makeover Monday

For week 13, we look at the the spending of different generations.

What works well?

  • Percentages are labelled clearly which makes comparisons easier.
  • Grid lines are simple.
  • Using a 100% stacked bar makes it easy to see part to whole relationships for each generation.

What could be improved?

  • There there is no indication of what the y-axis measures.
  • Some more context could be provided such as when the data was collected or what country the consumers are from.
  • Difficult to compare spending for categories across generations.

What Ryan did:

  • Converted the stacked bar into bar charts
  • Coloured each generation group
View on Tableau Public

What Marc did:

  • Created small multiple bar charts by category.
  • Colour-coded each generation.
  • Created desktop and mobile views on separate pages in Data Studio. Click the link to switch between versions.
View in Data Studio

Makeover Monday 2019 Week 12: The Reykjavik Index

Makeover Monday

The Reykjavik Index measures the extent to which men and women are perceived to be equally suited for positions of leadership. This week’s Makeover Monday chart shows the Reykjavik Index across the G7.

What works well?

  • Clean, uncluttered design
  • G7 Average is highlighted with a different colour

What could be improved?

  • Circular bars are misleading. A typical bar chart encodes data in the length of the bars. In a circular bar chart, the data is in fact encoded in the radial angle, which is more difficult to interpret.

What Ryan did:

  • Used a traditional bar chart.
  • Added a reference line to show the G7 average.
  • Colour-coded countries above average and below average.
View in Tableau Public

What Marc did:

  • Straightened the bars to allow easier comparison.
  • Added grey bars stacked to 100 to show the maximum extent of the index.
  • Kept the original colours and overall style.
View in Data Studio

Makeover Monday 2019 Week 10: World Development Indicators

Makeover Monday

This week’s Makeover Monday challenge is in association with Operation Fistula. The original chart is the following map showing adolescent fertility rates in Africa. However, the dataset provided does not include the data needed to reproduce this chart:

What works well?

  • Clean and simple. Well-labelled. Easy to understand.
  • Colours are muted and not distracting. Visually-pleasing.

What could be improved?

  • Legend should be placed closer to the map to aid the viewer.

What Marc did:

  • Focused on female life expectancy in African countries.
  • Used a geo chart in Data Studio to map the data.
  • Added a jitter plot to show the distribution of life expectancy across countries. The filter allows you to select a particular country and see it in context of the distribution.
View in Data Studio

Makeover Monday 2019 Week 9: Bicycle Imports in the U.K.

Makeover Monday

This week’s Makeover Monday dataset comes from a report on the economic value of the bicycle industry in the United Kingdom. The chart shows the quarterly trend in bicycle imports from 2010 to 2016.

What works well?

  • Use of a line chart makes the seasonal trend easy to see.
  • Line markers clearly indicate the quarterly data points.

What could be improved?

  • Labels and gridlines can be re-formatted to eliminate some non-data ink.
  • Vertical axis title can be re-oriented to make it easier to read.

What Marc did:

View in Data Studio
  • Kept original line chart style.
  • Simplified labels on both axes and horizontal label on vertical axis.
  • Added shading for 2016 to correspond with the insight presented in the caption.