Well, in Ireland recently we had an historic day when same sex marriage was voted in (first country in the world to do so…). It was also known as the Thirty-fourth Amendment of the Constitution (Marriage Equality) Bill 2015. You can read more about it at www.referendum.ie. I have to admit that I shed a few tears… as it was a wonderful moment for so many Irish gay people…

rainbow_flag

However, this blog is about Excel and I thought it would be interesting to use this data to answer a question I was recently asked by a customer. She had a list of doctors and she just needed to see how many hours they had been working and also to show an average.

So for this blog post I downloaded just the first 10 constituencies  from the Referendum website, calculated an average Total poll and created a chart to show this.

You can view the video below…

You can download the data here On the full data set tab, you can see the full list of constituencies if you want to play around with the data yourself…