I'm trying to create a Line chart with 3 lines showing the number of tickets we get that labeled 1) billing, 2) info or 3) troubleshooting by date. So I want
- the date column on the x
- the number of times a date in the date column appears with the same label in the label1 column on the y
I tried making a pivot table and failed--it doesn't seem to be compatible with my date column.
I feel like the solution involves countifs but I can't wrap my head around what to do next.
Can anyone offer any insight or point me the right direction?