Wednesday, June 21, 2017

Creating Pareto Charts just got easier!

On the 26th of September 2008, I published only my second ever video on YouTube: "How To... Create a Pareto Chart in Excel 2003" - I had published my first, "How To...Convert PowerPoint to iPod Movie", nearly a year earlier. At that time in one of my classes I needed to show students how to create a Pareto Chart which I did step-by-step in a Word document using screen shots. I recall viewing another "How To" video online but thinking that the content creator had done a poor job of explaining the steps, so I challenged myself to do better - here it is:

Over the years this video has been viewed 109,849 times, but in more recent years (as Excel 2003 gets used less and less) views have decined to 3 or 4 a day. It is now one of five videos I have on the channel - to date the Pareto Chart videos have totalled 506,122 views - not bad!

One of my more recent videos is about creating a Pareto chart in Excel 2016. Microsoft obviously recognised that this is a popular charting tool and have added it to the latest version of Excel. Gone is the need to rank the data, calculate cumulative values, calculate percentages, and manipulating the chart to get the end result. Excel does all this for you. See below how it is done today and compare this to what we had to do above in the good ol' days:

No comments:

Post a Comment