Chart for approaching Due Dates

[JayJoshi]

I have following columns in my data and would like to answer these question by creating a chart out of it:

Questions: 

1. Need a chart which shows How many tickets are approaching due dates?
2. Descending list of tickets approaching due dates i.e tickets with less days to due dates to tickets with more days to due dates?
3. How and which tickets have already crossed the due date?
4. How and which tickets have due date today?

Ticket ID	Ticket Type	Created Date	Due Date
1	Project	09/02/20	11/10/2020
2	Task	09/03/20	11/10/2020
3	Incident	09/03/20	10/3/2020
4	Incident	09/03/20	10/15/2020
5	Project	09/04/20	11/13/2020
6	Task	09/04/20	10/27/2020
7	Project	09/04/20	11/05/2020

*last ticket has due date as  of today. 

Can you please me with this?

@Rajesh_Sinha 

[#2]

@JayJoshi 

To fix the issue you need to summarize the data by using one Helper Column, and the name given to it is STATUS.

How it works:

• Formula in cell Y2:

=IF(X2>TODAY(),"Due Date Approachig",IF(X2=TODAY(),"Due Today","Due Date Crossed"))

• Create Pivot Tale.

Where Ticket Type in Row, Status in Column and Due Date are as Value (Count).

• Now create a Combo Pivot Chart.

N.B.

• Both PT & Pivot Chart can be filtered on Ticket Type and Status.