Forum Discussion
jeffr
8 years agoNew Member
chart with start and end date
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.
3 Replies
- Ashish_MathurSuper User
- v-jiascu-msftMicrosoft Employee
- v-jiascu-msftMicrosoft Employee
Hi jeffr,
Could you please mark the proper answer as solution or share the solution if it's convenient for you?
Best Regards!
Dale