Creating an S-Curve Chart in MS Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 26 ธ.ค. 2024

ความคิดเห็น • 70

  • @lioness814
    @lioness814 ปีที่แล้ว +2

    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.

  • @liziwesoxa4892
    @liziwesoxa4892 ปีที่แล้ว +5

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

  • @AurumHelaniMukhacwa
    @AurumHelaniMukhacwa 2 หลายเดือนก่อน

    If "knowledge is power", image what sharing knowledge in a best way possible is!!!
    Thank you sir.

  • @carlodigma5128
    @carlodigma5128 3 ปีที่แล้ว

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

  • @ma.janinaroqueranola8835
    @ma.janinaroqueranola8835 2 ปีที่แล้ว +1

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

  • @KillerSmileDota
    @KillerSmileDota 2 ปีที่แล้ว +1

    Clear, concise, very informative.

  • @m.fadziljufri5174
    @m.fadziljufri5174 2 ปีที่แล้ว +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!

  • @margiedeguzman6474
    @margiedeguzman6474 ปีที่แล้ว

    This is a very clear tutorial. Thanks👍

  • @anuoluwapoesan473
    @anuoluwapoesan473 10 หลายเดือนก่อน

    Thank you so much, well detailed and explicit.

    • @ExcelInsights
      @ExcelInsights  10 หลายเดือนก่อน

      Glad it was helpful!

  • @katylim6702
    @katylim6702 2 ปีที่แล้ว +1

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

  • @servanthood6135
    @servanthood6135 หลายเดือนก่อน

    Thank you sir for sharing this video.GBU

  • @sharookhanpn6688
    @sharookhanpn6688 3 หลายเดือนก่อน

    Very well said in simple way

  • @rodolfomendes6784
    @rodolfomendes6784 3 ปีที่แล้ว +1

    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.

  • @jayce0015
    @jayce0015 4 หลายเดือนก่อน +1

    Can you do the Planned vs. Actual Cummulative.

    • @ExcelInsights
      @ExcelInsights  4 หลายเดือนก่อน

      th-cam.com/video/mMdK61o2HeA/w-d-xo.htmlsi=Q7kLzpJyMdCrtlQ8

  • @roderickbalolong6795
    @roderickbalolong6795 2 ปีที่แล้ว

    Excellent Explanation, Thank you Sir.

  • @Anthony-op8sv
    @Anthony-op8sv 2 ปีที่แล้ว

    Helpful content, Salamat Sir!

  • @aungnaingshwe1014
    @aungnaingshwe1014 3 ปีที่แล้ว +1

    Thanks, this is really helpful!👍

  • @SholaOkunola
    @SholaOkunola 26 วันที่ผ่านมา

    can you use primavera p6 professional for the planned vs actuals instead of MS- Project

    • @ExcelInsights
      @ExcelInsights  26 วันที่ผ่านมา

      Yes, Primavera has built in reports and can do s curves on its own-- without the use of another software unlike how Project needs Excel.

  • @homesolutionsiloilo3354
    @homesolutionsiloilo3354 2 ปีที่แล้ว

    Thanks Sir for sharing your knowledge!

  • @abdullah_alhathloul_
    @abdullah_alhathloul_ 7 หลายเดือนก่อน

    very clear and useful , thanks

  • @wanadnan-wawa2446
    @wanadnan-wawa2446 ปีที่แล้ว

    Thank You.. Easy to understand

  • @Rolando-r9v
    @Rolando-r9v ปีที่แล้ว

    Thank you so much Sir for sharing.

  • @Kairosjansu
    @Kairosjansu 5 หลายเดือนก่อน

    Thank you, helping a lot

  • @Dodo.en112
    @Dodo.en112 ปีที่แล้ว

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

    • @ExcelInsights
      @ExcelInsights  ปีที่แล้ว

      Yes, you can. Please see this video:
      th-cam.com/video/mMdK61o2HeA/w-d-xo.htmlsi=fBkg9iuH7AlQuVGh

  • @safetv7085
    @safetv7085 2 ปีที่แล้ว

    Thank you so much! ☺️🙏🏼

  • @Brandi.Nicole
    @Brandi.Nicole 3 ปีที่แล้ว

    Reminder start at 3:05

    • @gulabjamun6897
      @gulabjamun6897 3 ปีที่แล้ว

      Hello Brandi

    • @Brandi.Nicole
      @Brandi.Nicole 3 ปีที่แล้ว

      @@gulabjamun6897 hi

    • @gulabjamun6897
      @gulabjamun6897 3 ปีที่แล้ว

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

  • @karlvincentaustriaoliveros6825
    @karlvincentaustriaoliveros6825 2 ปีที่แล้ว

    Thanks for sharing sir.

  • @amratakirpalani6451
    @amratakirpalani6451 ปีที่แล้ว

    how do you create an area chart from this information

    • @ExcelInsights
      @ExcelInsights  ปีที่แล้ว

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

  • @gibsondeepaquibulan4888
    @gibsondeepaquibulan4888 4 ปีที่แล้ว +2

    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  4 ปีที่แล้ว

      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 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  3 ปีที่แล้ว

      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 3 ปีที่แล้ว

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

  • @vinaytharakreddys8115
    @vinaytharakreddys8115 3 ปีที่แล้ว

    Superb bro

  • @boki7429
    @boki7429 3 ปีที่แล้ว

    Thank you. This helps

  • @EdwinHChaidir
    @EdwinHChaidir 4 ปีที่แล้ว

    Thanks for sharing

  • @deunfortunated
    @deunfortunated 2 ปีที่แล้ว

    Tyvm bro....

  • @zinabalhamam6941
    @zinabalhamam6941 ปีที่แล้ว

    thank you

  • @rodelgarcia7509
    @rodelgarcia7509 2 ปีที่แล้ว

    helpful thanks

  • @maxwelltaiping5739
    @maxwelltaiping5739 2 ปีที่แล้ว +1

    Malami salamat po

  • @SholaOkunola
    @SholaOkunola 27 วันที่ผ่านมา

  • @harrymazon3167
    @harrymazon3167 3 ปีที่แล้ว

    Thanks sir

  • @geldoes5282
    @geldoes5282 ปีที่แล้ว

    thankieeee!

  • @mjnav-ph1846
    @mjnav-ph1846 4 ปีที่แล้ว

    Hello