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
 
Top