Need dashboard for Resolved VS Created Tickets.

[JayJoshi]

Following is my snippet data for creating the dashboard. 

Ticket ID	Created	Status
1	11/03/2020	Closed
2	11/01/2020	To Do
3	10/28/2020	In Progress
4	10/25/2020	Closed

I would like to create the dashboard: Created VS Resolved. I am looking for something like this. (Image Attached) 

I really tried but could not get the solution. Can anyone please help me this?

@Rajesh_Sinha 

[#2]

You need one more Column for Dates named as Resolved.. it's like created on 01/01/2020 and resolved or closed on 01/10/2020.

[#3 · Accepted solution]

@JayJoshi 

You may try this:

How it works:

1. Create Pivot Table. 
2. Keep Date in ROW, Details in COLUMN and Ticket in VALUE and set COUNT for Ticket.
3. Select PT now from Design, then Layout & hit Grad Total, and click on for column only.
4. Then Create a Line Chart.

Note: Working with PT is a wise way to do this.

[#4]

@Rajesh_Sinha  Thank you so much. You are miracle Excel Expert.

[#5]

Glad to help you @JayJoshi ,,, keep asking ☺