Given today’s historic vote in the UK on whether to remain in or leave the EU, I decided to pull together a few charts into a single slide that would help frame the issue. The first two charts address the question of significance by showing first, that the UK economy is the second largest in the EU and accounts for 16% of EU GDP. The second stacked bar chart shows that 15% of UK GDP is driven by exports to the EU. The third chart focuses on the polling trend over the past several weeks and you can see that it’s too close to call. The final chart summarizes the projected economic impact on UK GDP from a vote to leave. You can see the scenarios, published by different groups, range from -1% to -6%.
I created this dashboard using ‘Insert Multiple Charts’ from the Mekko Graphics ribbon and selecting ‘Four Charts’. For the first stacked bar chart, I used a data column for % of Total because, given the small chart size, it was hard to read if I placed the segment values and labels inside the chart. For the second stacked bar, I also used a data column, but this time is was for text. I dragged the text to the left of the chart so it can be used as series labels. I chose to hide both the X and Y axes for both of the stacked bar charts to reduce visual clutter.
For the line chart, I added an axis break so you could see the variability in the smaller series “Don’t Know” over the time period. In the last chart, I added an average line and I highlighted the two IMF scenarios (base case of -1.5% and adverse case of -5%) by coloring these segments orange.
Here is the chart in SlideShare to download and edit using Mekko Graphics: