Here is a video that contains two messages:

1 The utterly pointless British general election that was held last week

2 How to take some basic data and create a useful single graphic butdynamic dashboard

The data on which this video is based is a 12 row table containing the overall results of the election by percentage of votes won by each political party. I have created a combo chart that shows the election otucome as a constant data series and then, using a combo box, I show each of 11 opinion polls’predictions from the days leading up to the election. I also created a Deviation % series for the graph and that shows just how useless some of these opinion polls are.

The video is here

and you can download the Excl file I created from UK_polling.


Duncan Williamson

13th June 2017

%d bloggers like this: