Creating an S-Curve Chart in MS Excel

  Рет қаралды 177,775

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 2 жыл бұрын
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
@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 9 ай бұрын
This is a very clear tutorial. Thanks👍
@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!
@KillerSmileDota
@KillerSmileDota Жыл бұрын
Clear, concise, very informative.
@ExcelInsights
@ExcelInsights Жыл бұрын
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.
@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!
@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!
@abdullah_alhathloul_
@abdullah_alhathloul_ 2 ай бұрын
very clear and useful , thanks
@boki7429
@boki7429 3 жыл бұрын
Thank you. This helps
@vinaytharakreddys8115
@vinaytharakreddys8115 3 жыл бұрын
Superb bro
@roderickbalolong6795
@roderickbalolong6795 Жыл бұрын
Excellent Explanation, Thank you Sir.
@ExcelInsights
@ExcelInsights Жыл бұрын
Thank you for watching!
@anuoluwapoesan473
@anuoluwapoesan473 5 ай бұрын
Thank you so much, well detailed and explicit.
@ExcelInsights
@ExcelInsights 5 ай бұрын
Glad it was helpful!
@homesolutionsiloilo3354
@homesolutionsiloilo3354 Жыл бұрын
Thanks Sir for sharing your knowledge!
@ExcelInsights
@ExcelInsights Жыл бұрын
Welcome!
@Kairosjansu
@Kairosjansu 27 күн бұрын
Thank you, helping a lot
@EdwinHChaidir
@EdwinHChaidir 3 жыл бұрын
Thanks for sharing
@Anthony-op8sv
@Anthony-op8sv Жыл бұрын
Helpful content, Salamat Sir!
@ExcelInsights
@ExcelInsights Жыл бұрын
Salamat sa panunuod
@wanadnan-wawa2446
@wanadnan-wawa2446 Жыл бұрын
Thank You.. Easy to understand
@ExcelInsights
@ExcelInsights Жыл бұрын
Thanks!
@user-js6xh7vg4o
@user-js6xh7vg4o Жыл бұрын
Thank you so much Sir for sharing.
@ExcelInsights
@ExcelInsights Жыл бұрын
Most welcome
@karlvincentaustriaoliveros6825
@karlvincentaustriaoliveros6825 2 жыл бұрын
Thanks for sharing sir.
@ExcelInsights
@ExcelInsights 2 жыл бұрын
You're welcome
@safetv7085
@safetv7085 Жыл бұрын
Thank you so much! ☺️🙏🏼
@ExcelInsights
@ExcelInsights Жыл бұрын
you're welcome!
@harrymazon3167
@harrymazon3167 3 жыл бұрын
Thanks sir
@deunfortunated
@deunfortunated Жыл бұрын
Tyvm bro....
@ExcelInsights
@ExcelInsights Жыл бұрын
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"
@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
@justjey1148
@justjey1148 3 жыл бұрын
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 Жыл бұрын
hi nice video. how to add another line? for comparison purposes?
@ExcelInsights
@ExcelInsights 10 ай бұрын
Yes, you can. Please see this video: kzfaq.info/get/bejne/o7OUfpli1JislXU.htmlsi=fBkg9iuH7AlQuVGh
@maxwelltaiping5739
@maxwelltaiping5739 2 жыл бұрын
Malami salamat po
@ExcelInsights
@ExcelInsights 2 жыл бұрын
Walang anuman
@amratakirpalani6451
@amratakirpalani6451 9 ай бұрын
how do you create an area chart from this information
@ExcelInsights
@ExcelInsights 9 ай бұрын
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
Create Planned Target vs Actual S-Curve from MS Project
11:16
Excel Insights
Рет қаралды 17 М.
Make This Awesome Gantt Chart in Excel (for Project Management)
17:13
Kenji Explains
Рет қаралды 233 М.
EVOLUTION OF ICE CREAM 😱 #shorts
00:11
Savage Vlogs
Рет қаралды 8 МЛН
Mama vs Son vs Daddy 😭🤣
00:13
DADDYSON SHOW
Рет қаралды 45 МЛН
WHAT’S THAT?
00:27
Natan por Aí
Рет қаралды 14 МЛН
Summer shower by Secret Vlog
00:17
Secret Vlog
Рет қаралды 13 МЛН
The Philosophy Behind  S-Curves
14:38
Project Control Academy
Рет қаралды 60 М.
Planned vs Actual chart in Excel | With Corrective Path
13:13
ExcelTips
Рет қаралды 40 М.
How to make S Curve in Microsoft Project | S Curve in Project Management
12:57
How to Make Gantt Chart in MS Excel
8:11
Excel Insights
Рет қаралды 43 М.
How To Make S-Curve Charts In Excel | Project Management | Office 365
5:29
Create Progress Curve step-by-step tutorial
38:48
Osama Saad
Рет қаралды 10 М.
Add an S Curve in Microsoft Excel. S Curve
4:28
ITsEasyTraining1st
Рет қаралды 40 М.
TECH-005 - Create a quick and simple Time Line (Gantt Chart) in Excel
9:36
The Excel Challenge
Рет қаралды 3,1 МЛН
Create S-Curve for Planned Target vs Actual Work from MS Project
8:05
EVOLUTION OF ICE CREAM 😱 #shorts
00:11
Savage Vlogs
Рет қаралды 8 МЛН