Comparing years in Excel Pivot chart
A common requirement in the business world is to compare financial information year to year to see what the trend is. Pivot tables and charts are commonly used to slice and dice the information. However, it is not always easy when comparing years in excel pivot charts.
Below is what you may get when you run your report. You can see all the months in a straight line.
However, you want to see the years on top of each other, something like this to identify trends or seasonality.
To achieve this you need to make use of the Grouping feature of Pivot Tables.
Right click on one of the dates and choose grouping as shown below.
Choose both the month and the year option and click OK as below
You will notice that your Pivot Table now shows the months and years separately and in the fields you now have a Years and Months item.
When you now move the Years into the columns section you can compare the years against each other
MS Excel in 2 minutes per week
Like what you’ve learnt above? Get a free 2 minute(or less) video clip once a week via our social media sites.
Easy to subscribe and unsubscribe, this is a good way to see what we can offer.
Learn more on the ‘Excel in 2 minutes’ page or click on the relevant icon to go to your preferred social media platform. The order of video clips release differs for each platform so subscribe to more if you want to learn quicker.