Actual Vs Planned Gantt Chart In One View - Project Management In Excel

Поделиться
HTML-код
  • Опубликовано: 22 авг 2024

Комментарии • 17

  • @reihanehfeiz2080
    @reihanehfeiz2080 Год назад +2

    thanks a lot, great as your other videos. I am reinventing the wheel by making an MS project schedule in Excel!!!
    The question, my Gantt chart for actual and planned values (error bars) is not aligned. How can I vertically align stacked and scatter error bars?

  • @SergeantBase
    @SergeantBase Год назад +1

    This was great, very creative. Makes me appreciate MS Project that much more, though haha

  • @m.s.am.s.a3283
    @m.s.am.s.a3283 6 дней назад

    the duration bar does come in the center of days complete and percentage bar. any idea how to make it at the bottom of it ? plz

  • @poetraabadi4608
    @poetraabadi4608 7 месяцев назад

    It is simple and easy to understand. To me it is still the best👍

  • @markbless8876
    @markbless8876 Год назад

    this is a powerful tool thank you... If you may, requesting i will be using the same approach to create a schedule timeline... Like i will place the break lunch and other offline activities on the same row per employee... like if i have 10 employee with different shifts and they have different lunch breaks others schedule both actual and planned... is this doable?

  • @kameshwararaoadhikesavalu1554
    @kameshwararaoadhikesavalu1554 Год назад

    Clear explanation.. can we create an additional error bar to compare another set of dates

  • @xosar28
    @xosar28 2 года назад

    After providing all of this great info, my boss was inquiring how to color code the Task labels 😪 ideas?

    • @Pacific998
      @Pacific998 2 года назад +1

      TELL him to buy Microsoft Project~

  • @elizabethsanmartin6270
    @elizabethsanmartin6270 Год назад +1

    Great videos!! When I tried to add the scatter chart with the start dates and axis labels, I don't get any dots on the chart ("Excel has returned these dots...").
    I see the axis labels, but no dots.
    Any suggestions?

  • @miguelangelaparicio3667
    @miguelangelaparicio3667 2 года назад

    Brother, You could do the same tutorial but with the Google spreadsheet (Sheets).
    Greetings from CDMX.

  • @YoungPensionados
    @YoungPensionados Год назад

    Hi, i try to add additional task (row). does it mean I need to redo the error bar?

  • @christandinewmachinesaerze9818
    @christandinewmachinesaerze9818 Год назад +1

    my planned error bars are way off in alingment. the first bar starts at the third or fourth row of the chart

  • @jillstraton5447
    @jillstraton5447 2 года назад

    Is this completed Excel available for download? Would love to use for my project

  • @matthewmalagarie1112
    @matthewmalagarie1112 8 месяцев назад

    Is a template available for download? Thanks!