ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Help with Pivot Chart (https://www.excelbanter.com/excel-worksheet-functions/14776-help-pivot-chart.html)

SteveJ

Help with Pivot Chart
 
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





All times are GMT +1. The time now is 05:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com