chart with start and end date

[jeffr]

I would like to create a line chart based on data that only has a start and end date.

Here is a sample of the data

Type Start Date End Date

IW	12/01/2017	12/31/2017
IW	12/01/2017	12/31/2017
JL	12/01/2017	12/31/2017
JL	12/01/2017	12/14/2017
EC	12/15/2017	12/31/2017
IW	12/01/2017	12/24/2017

Ideally it would group based on Type and then create a line chart with the Y Axis as Type and the X-Axis would be the Start Date to the End Date range.  Then for each day in between start and end it would have the Count of Type.

[v-jiascu-msft]

Hi @jeffr,

Could you please mark the proper answer as solution or share the solution if it's convenient for you?

Best Regards!
Dale

[v-jiascu-msft]

Hi @jeffr,

You still can try this solution here. (No relationship).

Best Regards,

Dale

[Ashish_Mathur]

Hi,

You may refer to my solution here.

Hope this helps.