Forum

Notifications
Clear all

Chart Help

2 Posts
2 Users
0 Reactions
79 Views
(@grider)
Posts: 1
New Member
Topic starter
 

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!

 
Posted : 05/11/2019 11:41 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Garrett,

Welcome to our forum!

You need to split your data out over the months it relates to. You can then plot the monthly data in your chart. See example file attached.

Mynda

 
Posted : 06/11/2019 8:34 am
Share: