Create a line chart using date and products

Hello all!

I have been trying quite hard to learn how to use Excel to create a Line chart to show number of support tickets for my products over a year. I will admit in my 10 attempts, I have learned fair bit, but I am not understanding enough to achieve what I want, neither do I know if want I want to achieve is even possible. This is what I would like to do:

Y axis number of total tickets for all products
X axis months January to December

On the X axis, I'd like the ability to toggle between years
So for example, show the number of tickets for 2017 or 2019

On the Y axis, I'd like the ability to toggle between all products and selecting a specific product
So for example showing all of the tickets by month for the year for one product or for all

I have attached my example spreadsheet, it has two columns:
Created On - currently has the date and time, I do not want or need the time. I will have data for 2017, 2018, 2019 and 2020
Product - The number of products I have are around 120 in total

Any advice or help with this would be incredibly appreciated. Once I see how this is done, it will fill the many holes in my knowledge and hopefully I can then build from that.

Thank you very much in advance!

Hi Olly, thank you so very much, this is very good, I love it and I really appreciate it!
Is there any way to combine all of the products by month?
Currently we see two products in February with a total of two tickets and in March we see one product two times with a total of 3 tickets.
I would really like to see the total for all products as a value by month and show a line for total tickets for all products by month over the year.
So this would be 12 points along the X axis.

I will play around and see if I can figure it out.

Many thanks again!

That worked a treat, thanks!
I am playing with this with real data, I am not sure how you did it but you somehow have the two extra fields, Months and Years, can advise how you did that please? I cannot seem to figure out it is done.

Thanks again!

Thanks for the advice, I tried this, I was able to Group by Month but it does not give me the months field to add to the Axis (Categories), also I cannot seem to figure out how you get the Slicer for Months and Years.
Any help here would be much appreciated.

Thanks!

Originally Posted by Olly

I'm really not sure what else to say, or show you. When you group date fields in a pivot table, the group levels you create become available as fields in your pivot table. Here's a quick GIF screen recording of me creating a pivot table, grouping dates, inserting year and month slicers...

This was excellent and just what I needed, to see how you did this. I really appreciate it, I learned a lot from this and I think I have what I wanted plus more. Thanks again!!