Skills level: Intermediate
Charts are a great way of displaying data visually. The reader is able to quickly spot trends and locate out-of-the-ordinary results.
I often need to work with rolling year on year growth, and I assumed that there was a quick fix in Excel to include a YOY growth figure in a chart, but turns out you need to be quite creative to get the desired result. While it is quite easy to calculate the growth rate with a few columns and formula’s, you need to know some charting skills to bring it into a chart.
Skill level: Advanced
One of the more exciting features of Excel, is its ability to create interactive charts - charts that change instantly as you change the criteria. Not only is it very impressive and makes you look like an expert, it is actually very easy to set up.
Just to give you an idea what an interactive chart would look like, see the chart below. By selecting the relevant department, the chart changes to show only the turnover data for the selected department.
(Don't pay too much attention to the figures, it might not make a lot of sense - I just used random data to generate the chart).
So here’s how to create an interactive pivot chart with the use of a slicer.
I have put together a simple data table with 3 columns for Date, Turnover and Department. There are 3 departments and the turnover data stretches over 6 years.
Hi, and welcome to my blog :) I am an Excel enthusiast and want to help others keen on improving their own Excel skills. I hope you learn something useful on my blog.