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.

[@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!

[@HajarSaila]

thank you for the video, I have try it but still unable to get s curve,

[@Alex-z25b]

Thank you for this. In my case the graph and table are balck, any help?

[@dcpowered]

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

[@ExcelInsights]

Great!

[@ba177ba18]

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

[@raj7553]

Hello Tom... As a planner we are creating a S curve for progress report based on the cumulative work but we track the update through % complete which is duration based. Is that the right way to do?

[@ExcelInsights]

An S-curve is usually for tracking accumulation of resources. Unless what you are planning is to visualize the accumulation of days worked-- your plan may work. Otherwise, it seems like what you wre creating is a line chart that shows progress of % complete-- not accumulation.

[@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

[@MrShahzaib7]

Can you tell me where this data is being taken from? I did exactly what you said but baseline commutative and commutative work both won't show anything at all. My box is empty and is not showing bar chart as yours.

[@ExcelInsights]

This happened to me before. From what I read, the OLAP is corrupted. The solution I found working was to copy the project data from the Gantt chart view and paste that on a new file.

[@MrShahzaib7]

@@ExcelInsights is it because of the resources? because i am not assigning resources as i have to only track % of the project and not the man hours or machine hours.

[@ExcelInsights]

Yes, the assignment of resources is part of the things you need to do exactly.

[@MrShahzaib7]

Hi there again. I have a problem which I think you can help me with. I have prepared a project schedule around 374 activities with start and end dates, now I want to show in an overview sheet which are the upcoming tasks for the coming week and late tasks also. Can you tell me how to do that? Is there any video which shows that? I am trying to highlight them but I am trying to show them in an overview dashboard. Please help.

[@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!

[@lapparellasignature9975]

God bless you man.

[@ammadkhan5380]

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

[@omarmneimneh-bj3vs]

I have same , please advise

[@narscalixto9029]

Hello, do you have the same for Primavera P6?

[@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!

[@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

[@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..?

[@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?

[@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.

[@OrleansMakuza]

Great Tutorial - Thanks!

[@ExcelInsights]

Glad it was helpful!

[@TomTaebterces]

how can I show day instead of week

[@parthachakraborty48]

Wonderful explanation

[@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.

[@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.

[@imamhandoyo3930]

Thank you ...helpful a lot

[@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

[@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.

[@abimazran7351]

how to show weightage in MIP??

[@muhammadzulhilmanmazlan9450]

why the value is zero for both baseline and actual? is it because I didn't enter the resources? please help

[@ExcelInsights]

Try declaring as Baseline1. Then, use Baseline1 Cumulative in the report

[@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

[@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. ^^

[@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?

[@muhammadamirin5088]

Why my filter dont have monthly to drag like vdeo

[@chanont6042]

Thx sir good job

[@ExcelInsights]

Thank you!

[@junegalsim]

Pagawa sana ako ng scurve

[@DfFg-qh5ub]

Weekly calender is field