Chart Help|Dashboards & Charts|Excel Forum|My Online Training Hub

Looking for some advice on how to build a time phased line chart.

I'm using power query to import and clean data and a part of that data is a start and end date. I have a total budget over that time period and need to spread that evenly across the time from the start and end date.

Ex:

Task             Start Date           End Date             Budget

Task A          10/31/2018         5/31/2019           $5,000

Task B          1/5/2019            6/27/2019           $10,000

Task C          10/31/2018        7/4/2019              $12,000

I have tens of thousands of lines of tasks and many of them are overlapping in time. I want to be able to visually portray the spikes and valleys of the business over time as tasks overlap. I want to display it on my line chart in monthly axis intervals. The assumption is that the budget is spread evenly each month. 

Any help is greatly appreciated!