I have a pivot table (Excel 2013) of results for a helpdesk. In column A it lists the agents, grouped by year (this divides up into months). In column 2 it lists the number of tickets closed by each of those agents.
I can't seem to create a graph of these numbers correctly. I want a line chart of number of tickets closed on the vertical axis, month on the horizontal axis and a line for each agent so I can compare them to each other.
Any idea how I might do this please?