2
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?
Please post a picture of what you have currently. (Add an image to imgur or somewhere and include the link in your post. I'll edit it in). – Byron Wall – 2015-06-02T14:26:59.240