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…
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…
[fvplayer src=”https://s3-eu-west-1.amazonaws.com/the-excel-expert/mixed_chart.mp4″]
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…
Thanks for posting these results as they make an interesting case to play around with.
I started by creating formulas instead of leaving everything hard coded and then transformed the lists into Excel Tables.
Just to see what I could see I created a correlation matrix out of the full data set but nothing interesting leapt out at me.
I then created a 2D bar chart of the differences between the total votes cast, net of spoiled papers and the average turnout of voters in numbers. I sorted the data from largest to smallest and got a rough and ready Tornado Graph which, I have to say, is much more informative than the 2D column chart, Average Total poll by constituency, that you prepared.
I haven’t watched the video so forgive me if I have done you a disservice!
Duncan
hi Duncan
Thank you so much. That’s brilliant! If you have done up a post on this, I’d love to post a link to it. Where I was coming from was that this was for a newbie Excel user. So I wanted to make sure that she could actually do this. What she requires right now is a bicycle..whereas what you have provided by the looks of things is a Ferrari 🙂