Analysis count and preferably graph of issues open

[mawilson12]

I have data that consists of dates/times an IT Helpdesk ticket was opened, and when it was closed.
What I would like is a count for each day how many were open (and thus being worked on).
Ideally ending in a format where I can put it in a line/column graph.
Can anyone point me in the right direction?
I don't know even what words I could use to search on!

 

[Eric W]

If your sheet looks something like this:

	A	B	C	D	E	F	G
1	Ticket	Open Date	Close Date		Date	Tickets
2	1	6/1/2018	6/1/2018		6/1/2018	3
3	2	6/1/2018	6/2/2018		6/2/2018	5
4	3	6/1/2018			6/3/2018	7
5	4	6/2/2018	6/2/2018		6/4/2018	7
6	5	6/2/2018	6/4/2018		6/5/2018	4
7	6	6/2/2018	6/3/2018		6/6/2018	4
8	7	6/3/2018			6/7/2018	4
9	8	6/3/2018	6/4/2018
10	9	6/3/2018	6/4/2018
11	10	6/3/2018	6/3/2018
12	11	6/4/2018
13	12	6/4/2018
14
15

<tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula F2 =SUMPRODUCT(--($B$2:$B$20<=E2),($C$2:$C$20>=E2)+($C$2:$C$20=""),--($A$2:$A$20<>"")) <tbody> </tbody>

<tbody>
</tbody>

Then you can use the formula in F2 to figure out how many tickets are open on the given day. Once you have that set up, just select columns E:F, go to the Insert tab and click Recommended Charts. Either the Histogram or the Line chart should work, depending on your preferences.