Help with PivotChart

S

Steve

I have a sheet that tracks tickets.

Col - A = Ticket Number
Col - B = Date Open
Col - C = Date Closed


I need to create a line chart that shows 1 colored line for tickets
open for each month

and another colored line showing tickets closed for each month

There are tickets that remain open from more than aa single month.

I can create a chart for 1 but I don't know how to do it to show both.

Any ideas?
Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
tickets and numbering them. 0
Doughnut Chart linked with the slicer in the pivot table 0
Creating a printable raffle ticket with serial numbers 0
Help with Pivot Chart 0
Showing two 'counts' on the same row 4
Auto Merge text from multiple sources 0
Using Microsoft Access as a Service Ticket Write-up program 0

Top