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?

1
  • 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
    Jun 2, 2015 at 14:26

1 Answer 1

1

For your Pivot Chart to work correctly, you'll need to setup your Pivot Table like this:

  • Legend (Series) Agent
  • Axis (Categories) Date
  • Values Sum of Closed Tickets

Your chart will then reflect the changes. This assumes your initial data set has at least those three columns (agent, date, closed ticket count). Once setup this way, you can group your date data by whatever interval you like (e.g. month, quarter, year).

This example uses a Pivot Chart (but you have more formatting flexibility with a standard chart):

Pivot Chart layout

1
  • Thanks dav. That helped. I figured out from your diagram that I needed to drag 'Agent' to the 'Column' area in the pivot fields. That worked perfectly. Many thanks.
    – Tim
    Jun 15, 2015 at 7:15

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .