Create Planned Target vs Actual S-Curve from MS Project

This video demonstrates how to create an S-Curve from MS Project to show both the Target and Actual work. Since you cannot delete data from the Pivot Table that MS Project produces, you need to transfer the data from the Pivot to another worksheet so that you can cut the Actual line to just where it should stop.

[@dannielemilio]

thanks!

[@chanont6042]

Good job

[@majdwehbe3297]

I am not finding the baseline cumulative work when editing the template in the available fields, how to add it?

[@user-jv1ch8rx7v]

Good day, Engr. What if the data in the cumulative work and baseline cumulative work is not accumulating?

[@-LyEngineer-zm4dw]

Thanks for sharing! I followed all the steps but in the Excel File the data of Baseline Cumulative Work and Cumulative Actual Work didn't show any data or numbers. Could you please advise how to fix this? Appreciate your reply!

[@avishekkumar749]

Can we create the S curve with the Material resource instead of Work?

[@nurulsyahira5516]

Thanks for sharing! Do we need to key in the cost to generate the data? I followed your tutorial but it did not work. Hope you can assist with this. Thank you.

[@nurulsyahira5516]

I already at resources in the programme (Resource Type - Cost) but I still cant generate the report

[@jmck1960ful]

How do you get the weekly calendar filter to appear?

[@ExcelInsights]

You need to keep clicking the square toggle buttons.

[@benpienaar2310]

Hi Donny. When creating the visual report, a different progress update (previous month) is being generated in excel and calculates wrong percentages. Please advise.

[@ExcelInsights]

Not sure what exactly is going on there but when you are in the part where you check fields to export, you can try to check everything that has "cumulative" on it and see if any of them reflects the current month/updates.

[@user-pp8vd5gk4x]

How does the data come in an excel sheet? and how the project calculates the data based on dates or costs?

[@ExcelInsights]

Hi, how it was exported to Excel is in the video. Not sure about your second question: do you mean how Project calculates cost? You may want to watch other videos in the playlist to see how you should enter the cost of each resource yourself. You cannot create an S-Curve with dates.

[@feliciafrisca6123]

Hi, I have done creating the S curve, however, my baseline accumulative was 0 and the accumulative work was fine. Is there any missing step that I should do? Thanks

[@ExcelInsights]

Hi, did you declare a baseline when you initially created your Gantt chart?

[@feliciafrisca6123]

@@ExcelInsights hi Yes, I already set the baseline, then I change start and finish into baseline start and baseline finish

[@suddenlee5874]

The data that was generated in excel for both baseline cumulative work and cumulative actual work was 0 for me, what am I missing?

[@gerhardhough8138]

I have the same problem, did you manage to resolve? Do you need the cost for the activities before it will generate?

[@hansontan3149]

I'm having same issue too. Any advice?

[@ExcelInsights]

Hi, have you added resources and their costs?

[@hansontan3149]

@@ExcelInsights I'm sorry, not sure how to do that.

[@ExcelInsights]

Try this kzbin.info/www/bejne/d3_afKiCe6tga6s

[@daniprasetyo3942]

Hi bro, could you help me, i have followed your way but i have some problems. First when i adjust the date to be late on week for example, following task will be adjusted automatically shorter one week. So that, the cumulative will be same after all. What makes this thing happen? Thank in advance

[@ExcelInsights]

Do you mean: if you adjust a task, the next task should stay in place, or be pushed? If stay in place, you need to disconnect the link between the task. If need to push forward, create a link between the task. If the second task does not move, right click on the second task and remove any Constraint

[@congcong93]

Hi , why my chart value is all 0 pls help

[@user-ih5qf9oj6f]

Hi, can i get some help. Actually i just need to show my target % vs actual % I've been searching 100 videos, and none have done so. is microsoft project unable to do such simple task? im abit frustrated

[@ExcelInsights]

Hi Timothy, do you want to show this in the S-Curve report?

[@user-ih5qf9oj6f]

hi, nope, i actualy want to show this on the column. i got a sample (PDF) but im not sure how to recreate it. @@ExcelInsights

[@cllo325]

Hi , my msp hang when ever i clicked on the "visual report "tab🙃

[@ExcelInsights]

If this only happens in that specific task, you need to repair/reinstall your MS Project