Creating an S-Curve Chart in MS Excel

Join our virtual classes here:
Facebook Chat: / insightsmanila
Website: www.insightsma...
Email: [e-mail]
Mobile / Viber: [phone]
S-Curve depicts the cost or man-hour distribution over the timeline of the project. Though many programs can create S-Curves automatically, it may help to know how easy it is to create an S-Curve using MS Excel.

[@liziwesoxa4892]

Clear and straightforward to the point. Thank you for this information 🙏

[@lioness814]

Thank you. very easy to absorb. I had been idle during the last 7years and seems like my know-how had been a thing of the past. It's time to get back to where I was. Learning again for personal growth at 48.

[@ExcelInsights]

Glad it helped!

[@ma.janinaroqueranola8835]

Thank you po sir for the well-explained video lecture po. It made me understand better how to create the s-curve using excel. During college days, we did this in manual po. Kudos po 🙏💪

[@carlodigma5128]

New Igorots subscriber, thanks for your video. Good now Filipinos are now sharing their talents. Halos kasi ibang lahi ang Indian ang pinaka marami.

[@ExcelInsights]

Thank you, sir!

[@m.fadziljufri5174]

Very good explanation, you made things become simple,. I thank you for that. Appreciate the efforts in this video.

[@ExcelInsights]

Thank you for watching, see you in the next video!

[@katylim6702]

Thank you for sharing! You explained it very well. I appreciate the efforts you put up into this video.

[@ExcelInsights]

Thank you!

[@KillerSmileDota]

Clear, concise, very informative.

[@ExcelInsights]

Thank you

[@anuoluwapoesan473]

Thank you so much, well detailed and explicit.

[@ExcelInsights]

Glad it was helpful!

[@abdullah_alhathloul_]

very clear and useful , thanks

[@margiedeguzman6474]

This is a very clear tutorial. Thanks👍

[@rodolfomendes6784]

Thanks for sharing this video man. You´re helpd me a lot!! Stay safe!

[@StickFiguresMaster]

If you learn curves with the percentage bar graphs, you have to most of the time use division, subtraction and addition if not multiplication to find your influx, you raises, your falling percentages by their rates.
If a company has 1000 dollars of a budget and 300 dollars is being used to by equipment, talk to businesses about selling their wares, then the sum of the budget has in its hands a “balance” of 300$ being currently used to find business to associate the business to.
If the rate of sales depend on a fully weekly graph then let’s say you have a month to see your decreases or increases by the end where everything tallies the idea of what’s in everybody’s best interests within the business for making money.
If that business buys the right to have property of another companies products sold, as long as it’s in legal documents that their aware that they are sharing their trades with another company after a lawyer and a judge define it’s a legal practice, then by the way things would look, 1,000 dollars is in theory 100% excluding the extra 0 as it’s an invisible extra 10s table that would only ever be inserted as long as 1000’s have been reached by the money’s means.
So 300$ of the 1,000 is like saying they want to invest in a company by trying to acquire 30%
Now I didn’t mention employees other then 2 companies and some legal people like a judge and lawyer, as long as there’s no such thing as employees well then this doesn’t yet have a division table of how much money a employee makes and by sums of weeks and or months.

[@Kairosjansu]

Thank you, helping a lot

[@roderickbalolong6795]

Excellent Explanation, Thank you Sir.

[@ExcelInsights]

Thank you for watching!

[@Anthony-op8sv]

Helpful content, Salamat Sir!

[@ExcelInsights]

Salamat sa panunuod

[@homesolutionsiloilo3354]

Thanks Sir for sharing your knowledge!

[@ExcelInsights]

Welcome!

[@aungnaingshwe1014]

Thanks, this is really helpful!👍

[@wanadnan-wawa2446]

Thank You.. Easy to understand

[@ExcelInsights]

Thanks!

[@user-js6xh7vg4o]

Thank you so much Sir for sharing.

[@ExcelInsights]

Most welcome

[@safetv7085]

Thank you so much! ☺️🙏🏼

[@ExcelInsights]

you're welcome!

[@boki7429]

Thank you. This helps

[@karlvincentaustriaoliveros6825]

Thanks for sharing sir.

[@ExcelInsights]

You're welcome

[@vinaytharakreddys8115]

Superb bro

[@zinabalhamam6941]

thank you

[@ExcelInsights]

Thank you for watching!

[@mrqwickie3423]

hi nice video. how to add another line? for comparison purposes?

[@ExcelInsights]

Yes, you can. Please see this video:
ruclips.net/video/mMdK61o2HeA/видео.htmlsi=fBkg9iuH7AlQuVGh

[@gibsondeepaquibulan4888]

Hi Sir, new subscriber here! I applied all the steps to create the S-Curve but when i insert the graph there is no Lines only markers but i selected the option line with markers. It would be a great help sir. Thank you!

[@ExcelInsights]

Hi, are you sure you selected line chart? You may also want to right click on the supposedly position of the lines (or markers) and click Format Data Series. From here, you may find an option that declares the color of the chart. It could have defaulted to "No Line"

[@maxwelltaiping5739]

Malami salamat po

[@ExcelInsights]

Walang anuman

[@EdwinHChaidir]

Thanks for sharing

[@Brandi.Nicole]

Reminder start at 3:05

[@gulabjamun6897]

Hello Brandi

[@Brandi.Nicole]

@@gulabjamun6897 hi

[@gulabjamun6897]

@@Brandi.Nicole Do you know Excel fully, I have some queries. I don't have anybody to correspond.
Can you Help?

[@deunfortunated]

Tyvm bro....

[@ExcelInsights]

You're welcome.

[@geldoes5282]

thankieeee!

[@ExcelInsights]

You're welcome

[@amratakirpalani6451]

how do you create an area chart from this information

[@ExcelInsights]

Hi, you just have to change the chart type to Area Chart after you create the line chart

[@harrymazon3167]

Thanks sir

[@justjey1148]

Hi sir. Just asking if s curve always need to be 100 percent in the graph or its just an actual progress? Meaning the project is still ongoing.

[@ExcelInsights]

Hi, an S-curve is meant to show your "plan" (or baseline) on how the project will go. If the project is ongoing, you can then create a progressive or "actual" s-curve to see the variance.

[@justjey1148]

@@ExcelInsights thank u sir. Its a little bit too late but i appreciate your reply.

[@rodelgarcia7509]

helpful thanks

[@ExcelInsights]

You're welcome

[@mjnav-ph1846]

Hello