#MakeoverMonday Data Studio Edition: Reykjavik Index for Leadership in G7 Countries

1. Add values for the remainder (100 - index)
2. Add a sort column
3. Pivot the data so that the index and the remainder were in the same column

WHAT WORKED WELL

• To create the stacked bar chart, all you need to do is select the chart type and drop the fields on the appropriate shelves.
• Customizing the split of the colors for the index and the remainder was easy.
• I was able to customize the size of the viz.
• You can choose any font that Google supports!!
• The tooltips are super responsive.
• Everything looks very crisp.
• Hiding the gridlines leaves a nice thin black line on the y-axis without me needing to fiddle around with a few different settings.
• The overall UX is quite intuitive. I see they have a data explorer now too.

• I couldn't find a way to show only the mark labels for the purple bars.
• I couldn't add a reference line for the G7 average so I had to leave it in the view.
• I couldn't hide the x-axis only. When you do, the y-axis gets hidden as well.