Creating an S-Curve Chart in MS Excel

  Рет қаралды 173,623

Excel Insights

Excel Insights

Күн бұрын

Join our virtual classes here:
Facebook Chat: / insightsmanila
Website: www.insightsmanila.com/webina...
Email: inquire@insightsmanila.com
Mobile / Viber: +639157343012
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.

Пікірлер: 62
@liziwesoxa4892
@liziwesoxa4892 Жыл бұрын
Clear and straightforward to the point. Thank you for this information 🙏
@ma.janinaroqueranola8835
@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 🙏💪
@liemdamanik
@liemdamanik Күн бұрын
Thank you, helping a lot
@lioness814
@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
@ExcelInsights Жыл бұрын
Glad it helped!
@aungnaingshwe1014
@aungnaingshwe1014 2 жыл бұрын
Thanks, this is really helpful!👍
@margiedeguzman6474
@margiedeguzman6474 8 ай бұрын
This is a very clear tutorial. Thanks👍
@KillerSmileDota
@KillerSmileDota Жыл бұрын
Clear, concise, very informative.
@ExcelInsights
@ExcelInsights Жыл бұрын
Thank you
@katylim6702
@katylim6702 2 жыл бұрын
Thank you for sharing! You explained it very well. I appreciate the efforts you put up into this video.
@ExcelInsights
@ExcelInsights 2 жыл бұрын
Thank you!
@rodolfomendes6784
@rodolfomendes6784 3 жыл бұрын
Thanks for sharing this video man. You´re helpd me a lot!! Stay safe!
@StickFiguresMaster
@StickFiguresMaster 3 жыл бұрын
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.
@carlodigma5128
@carlodigma5128 2 жыл бұрын
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
@ExcelInsights 2 жыл бұрын
Thank you, sir!
@m.fadziljufri5174
@m.fadziljufri5174 2 жыл бұрын
Very good explanation, you made things become simple,. I thank you for that. Appreciate the efforts in this video.
@ExcelInsights
@ExcelInsights 2 жыл бұрын
Thank you for watching, see you in the next video!
@vinaytharakreddys8115
@vinaytharakreddys8115 3 жыл бұрын
Superb bro
@abdullah_alhathloul_
@abdullah_alhathloul_ Ай бұрын
very clear and useful , thanks
@boki7429
@boki7429 3 жыл бұрын
Thank you. This helps
@EdwinHChaidir
@EdwinHChaidir 3 жыл бұрын
Thanks for sharing
@anuoluwapoesan473
@anuoluwapoesan473 4 ай бұрын
Thank you so much, well detailed and explicit.
@ExcelInsights
@ExcelInsights 4 ай бұрын
Glad it was helpful!
@roderickbalolong6795
@roderickbalolong6795 Жыл бұрын
Excellent Explanation, Thank you Sir.
@ExcelInsights
@ExcelInsights Жыл бұрын
Thank you for watching!
@homesolutionsiloilo3354
@homesolutionsiloilo3354 Жыл бұрын
Thanks Sir for sharing your knowledge!
@ExcelInsights
@ExcelInsights Жыл бұрын
Welcome!
@Anthony-op8sv
@Anthony-op8sv Жыл бұрын
Helpful content, Salamat Sir!
@ExcelInsights
@ExcelInsights Жыл бұрын
Salamat sa panunuod
@harrymazon3167
@harrymazon3167 2 жыл бұрын
Thanks sir
@wanadnan-wawa2446
@wanadnan-wawa2446 Жыл бұрын
Thank You.. Easy to understand
@ExcelInsights
@ExcelInsights Жыл бұрын
Thanks!
@safetv7085
@safetv7085 Жыл бұрын
Thank you so much! ☺️🙏🏼
@ExcelInsights
@ExcelInsights Жыл бұрын
you're welcome!
@user-js6xh7vg4o
@user-js6xh7vg4o 11 ай бұрын
Thank you so much Sir for sharing.
@ExcelInsights
@ExcelInsights 11 ай бұрын
Most welcome
@karlvincentaustriaoliveros6825
@karlvincentaustriaoliveros6825 2 жыл бұрын
Thanks for sharing sir.
@ExcelInsights
@ExcelInsights 2 жыл бұрын
You're welcome
@gibsondeepaquibulan4888
@gibsondeepaquibulan4888 3 жыл бұрын
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
@ExcelInsights 3 жыл бұрын
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"
@justjey1148
@justjey1148 2 жыл бұрын
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
@ExcelInsights 2 жыл бұрын
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
@justjey1148 2 жыл бұрын
@@ExcelInsights thank u sir. Its a little bit too late but i appreciate your reply.
@mrqwickie3423
@mrqwickie3423 11 ай бұрын
hi nice video. how to add another line? for comparison purposes?
@ExcelInsights
@ExcelInsights 9 ай бұрын
Yes, you can. Please see this video: kzbin.info/www/bejne/o37HfGlnpJd7m6Msi=fBkg9iuH7AlQuVGh
@deunfortunated
@deunfortunated Жыл бұрын
Tyvm bro....
@ExcelInsights
@ExcelInsights Жыл бұрын
You're welcome.
@rodelgarcia7509
@rodelgarcia7509 Жыл бұрын
helpful thanks
@ExcelInsights
@ExcelInsights Жыл бұрын
You're welcome
@zinabalhamam6941
@zinabalhamam6941 Жыл бұрын
thank you
@ExcelInsights
@ExcelInsights Жыл бұрын
Thank you for watching!
@geldoes5282
@geldoes5282 Жыл бұрын
thankieeee!
@ExcelInsights
@ExcelInsights Жыл бұрын
You're welcome
@maxwelltaiping5739
@maxwelltaiping5739 2 жыл бұрын
Malami salamat po
@ExcelInsights
@ExcelInsights 2 жыл бұрын
Walang anuman
@amratakirpalani6451
@amratakirpalani6451 8 ай бұрын
how do you create an area chart from this information
@ExcelInsights
@ExcelInsights 8 ай бұрын
Hi, you just have to change the chart type to Area Chart after you create the line chart
@Brandi.Nicole
@Brandi.Nicole 2 жыл бұрын
Reminder start at 3:05
@gulabjamun6897
@gulabjamun6897 2 жыл бұрын
Hello Brandi
@Brandi.Nicole
@Brandi.Nicole 2 жыл бұрын
@@gulabjamun6897 hi
@gulabjamun6897
@gulabjamun6897 2 жыл бұрын
@@Brandi.Nicole Do you know Excel fully, I have some queries. I don't have anybody to correspond. Can you Help?
@mjnav-ph1846
@mjnav-ph1846 3 жыл бұрын
Hello
The Philosophy Behind  S-Curves
14:38
Project Control Academy
Рет қаралды 60 М.
Make This Awesome Gantt Chart in Excel (for Project Management)
17:13
Kenji Explains
Рет қаралды 193 М.
Heartwarming: Stranger Saves Puppy from Hot Car #shorts
00:22
Fabiosa Best Lifehacks
Рет қаралды 19 МЛН
Khó thế mà cũng làm được || How did the police do that? #shorts
01:00
MEU IRMÃO FICOU FAMOSO
00:52
Matheus Kriwat
Рет қаралды 46 МЛН
Create Planned Target vs Actual S-Curve from MS Project
11:16
Excel Insights
Рет қаралды 16 М.
How to make S Curve in Microsoft Project | S Curve in Project Management
12:57
How To Make S-Curve Charts In Excel | Project Management | Office 365
5:29
Graphing P6 S-Curves in EXCEL
17:13
Plan Academy Inc.
Рет қаралды 9 М.
How to make Project's S-curve
14:27
ELglobo Academy
Рет қаралды 112 М.
Risk Register Template using MS Excel
19:27
Excel Insights
Рет қаралды 23 М.
How to Use S-Curve Analysis in Project Management
2:20
Planned vs Actual chart in Excel | With Corrective Path
13:13
ExcelTips
Рет қаралды 39 М.
S-Curve for Project Management (with Excel template)
15:33
Kandis Porter
Рет қаралды 13 М.
Heartwarming: Stranger Saves Puppy from Hot Car #shorts
00:22
Fabiosa Best Lifehacks
Рет қаралды 19 МЛН