Create S-Curve for Planned Target vs Actual Work from MS Project

This video demonstrates how to create an S-Curve from MS Project to show both the Target and Actual work from a completed project.

[@ba177ba18]

Clear and straight to the point. Thank you. Liked and subbed

[@DeepakKumar-gt6tg]

very informative and helped in creating S curve. Thanks for in depth explanation!

[@leumntv9741]

Wow! So love this channel. Thank you very much for sharing this tutorial

[@ExcelInsights]

Glad you liked it!

[@christang9406]

Thanks sir, i managed to create the curve as instructed. I forgot to make the work baseline in the beginning. and the tick options.. Thank you!

[@dcpowered]

This is perfect! Just what i was looking for! Great explanations!

[@ExcelInsights]

Great!

[@parthachakraborty48]

Wonderful explanation

[@imamhandoyo3930]

Thank you ...helpful a lot

[@syafeeqahsofi5326]

Hi sir, from available fields from visual reports, i dont have baseline cumulative work and cumulative work to add to selected fields.. what to do sir..?

[@ammadkhan5380]

I'm having 0 for all fields (actual work, cumulative work) in graph report, I have set baseline. Need help

[@OrleansMakuza]

Great Tutorial - Thanks!

[@ExcelInsights]

Glad it was helpful!

[@MuhammadZubair-jl4nn]

Sir, Thanks for guidance. please prepare one more video to guide us that how we can create "critical task report" in progress tab.

[@shaikaarifilahi8423]

thanks for the information, but while I am generating the s curve report (baseline cumulative work VS Cumulative actual work), I am getting values 0 in the pivot table. unable to generate the s curve. would you pls help me with that?

[@jongski18]

You should do resource loading to your schedule to be able to generate values.

[@nisarkhan2619]

same problem i am facing and don’t know how to do resource loading in existing project file

[@shyam1027]

This is truly outstanding and precise explanation! . Is it possible to assess or forecast the future rate of work by S-curve?

[@ExcelInsights]

Excel can do this by means of regression analysis. However, it requires that your dates are evenly separated.

[@warrenjames5658]

Hi Excel Insights. Thank you for the awesome video. Can you kindly compile a video on EVM analysis. Computing EV, PV and AC. Thank you

[@ExcelInsights]

Hi, There is a templated report in MS Project that already does this.

[@nurdiyana2945]

do i need to complete all the actual start and finish date to generate the report? because i have set the baseline but the date are not complete yet as the project is ongoing, when i generate the report all the cummulative value in excel is 0

[@ExcelInsights]

Hi, here's a video if the project is still ongoing: kzbin.info/www/bejne/aonNe2uil6aqZ5Ysi=lfH7AV4-EVHUFWfR

[@filipefigueiredo85]

That's a great tutorial. Is possible to build the same chart but considering only Material Resource type?

[@muhammadamirin5088]

Why my filter dont have monthly to drag like vdeo

[@narscalixto9029]

Hello, do you have the same for Primavera P6?

[@junegalsim]

Pagawa sana ako ng scurve

[@ruigamito]

Hi! Many thanks for the video. Is it posible to do this curve for a daily calendar?

[@ExcelInsights]

Yes, you just need to continue collapsing the Excel data to daily. However, daily curves tend to be not as smooth looking as weekly curves.

[@danishaiman5952]

hi,urgent may i ask why my baseline cumulative is all 0 ? but mu actual cumulative has the value

[@ExcelInsights]

Did u declare baseline?

[@lynnettekm1661]

@@ExcelInsights I am having the same issue...My values are all 0...The Chart is completely empty with no histogram

[@pepenator79]

Same thing happens in my case@@lynnettekm1661

[@hargovindbhatt8284]

@Excellnsights i have same issue to show all 0 in the data set and no histogram has shown..

[@adedigbaafeezadedayo2324]

I'm having similar problem. .it keeps bringing 0

[@giacomov83]

Thanks a lot. Could you please clarify how to show different bars for baseline and actual/planned?

[@ExcelInsights]

Hi, do you mean you want to show the chart as a bar/column chart instead of a line chart? Because if yes, then that is not an S-Curve anymore. Did I understand your question correctly?

[@giacomov83]

@@ExcelInsights sorry..I was meaning the view in tracking Gantt with bar charts of planned Vs baseline..that is how normally tracking Gantt displays the Gantt chart! Solved!

[@oootoob]

This can be done directly in Project using reports. But how can you show work completed as a percentage rather than hours?

[@davidt.akin9096]

You can do this using cumulative percentage complete

[@abimazran7351]

how to show weightage in MIP??

[@chanont6042]

Thx sir good job

[@ExcelInsights]

Thank you!

[@amirulh166]

What represent number for baseline and actual cumulative work? what does the work number mean?

[@ExcelInsights]

This is auto calculated based on the dates (both the initial and actual) you enter in the Gantt chart.

[@pmodepartment]

Sir, how can it change the value from work hours to percentage value based on % complete column in gantt chart ?

[@ExcelInsights]

During the export part, look for the % column you are looking for

[@kornvisanuthongrat5656]

Thank you for shared the good thing!! But i have some issue, In visual report field picker, it doesn't show Baseline Cumulative Work and also no Cumulative Actual Work. Please feedback me how to make it appear. hope you can help __/\__ (I'm use MSP version 2010 )

[@ExcelInsights]

This was a problem with Project 2010 (and actually other programs too had many problems during the launch of 2010 versions that Microsoft released what we call "Service Pack 1" that fixed many issues in the 2010 versions.) I cannot find the link to it anymore. Maybe you can be lucky and find the "Service Pack 1" update or get the more recent versions of MS Project.

[@kornvisanuthongrat5656]

@@ExcelInsights Thank you for your reply sir, I will try to get the update version. ^^

[@DfFg-qh5ub]

Weekly calender is field

[@redstoneengineeringandcons3301]

Hi Excel Insights, how to extract the manpower histogram? Kindly share the link kung may video na kayo regarding dito. Salamat

[@ExcelInsights]

Do you mean histogram per week Yung buckets?