Creating an S-Curve Chart in MS Excel

Join our virtual classes here:
Facebook Chat: / insightsmanila
Website: www.insightsmanila.com/webina...
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 🙏

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

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

[@katylim6702]

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

[@ExcelInsights]

Thank you!

[@aungnaingshwe1014]

Thanks, this is really helpful!👍

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

[@margiedeguzman6474]

This is a very clear tutorial. Thanks👍

[@KillerSmileDota]

Clear, concise, very informative.

[@ExcelInsights]

Thank you

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

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

[@boki7429]

Thank you. This helps

[@abdullah_alhathloul_]

very clear and useful , thanks

[@vinaytharakreddys8115]

Superb bro

[@anuoluwapoesan473]

Thank you so much, well detailed and explicit.

[@ExcelInsights]

Glad it was helpful!

[@EdwinHChaidir]

Thanks for sharing

[@homesolutionsiloilo3354]

Thanks Sir for sharing your knowledge!

[@ExcelInsights]

Welcome!

[@roderickbalolong6795]

Excellent Explanation, Thank you Sir.

[@ExcelInsights]

Thank you for watching!

[@Kairosjansu]

Thank you, helping a lot

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

[@Anthony-op8sv]

Helpful content, Salamat Sir!

[@ExcelInsights]

Salamat sa panunuod

[@safetv7085]

Thank you so much! ☺️🙏🏼

[@ExcelInsights]

you're welcome!

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

[@harrymazon3167]

Thanks sir

[@wanadnan-wawa2446]

Thank You.. Easy to understand

[@ExcelInsights]

Thanks!

[@user-js6xh7vg4o]

Thank you so much Sir for sharing.

[@ExcelInsights]

Most welcome

[@karlvincentaustriaoliveros6825]

Thanks for sharing sir.

[@ExcelInsights]

You're welcome

[@mrqwickie3423]

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

[@ExcelInsights]

Yes, you can. Please see this video:
czcams.com/video/mMdK61o2HeA/video.htmlsi=fBkg9iuH7AlQuVGh

[@deunfortunated]

Tyvm bro....

[@ExcelInsights]

You're welcome.

[@zinabalhamam6941]

thank you

[@ExcelInsights]

Thank you for watching!

[@maxwelltaiping5739]

Malami salamat po

[@ExcelInsights]

Walang anuman

[@rodelgarcia7509]

helpful thanks

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

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

[@mjnav-ph1846]

Hello