Notifications
Clear all
Power Pivot
2
Posts
2
Users
0
Reactions
70
Views
Topic starter
Good Day. Is it possible for a pivot chart to display two years of monthly data, such as 2021 and 2022, as two separate 12 month lines for a yearly comparison? When I choose both years from the slicer, my pivot chart shows two years of monthly data as a single line of 24 months. An example of the desired chart is in the attached.
I am learning to use pivot tables and slicers and really appreciate the examples and videos on your website.
Posted : 24/05/2023 6:15 am
Please have a look at the attached file and see if it does what you need and if you can replicate it in your own.
I didn't use a Slicer but the file demonstrate the time intelligence features of Pivot Tables. Come back here when you get stuck and perhaps you can upload a file of your own.
Posted : 24/05/2023 6:28 am
