How to Add a Target Line in an Excel Graph

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

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

  • @abowles79
    @abowles79 2 года назад +6

    Best tutorial, nice and clear and simple. Been hunting for a lesson this straight forward, well put together. Thanks-

  • @abc123ohio
    @abc123ohio 5 месяцев назад +1

    Perfect. Thank you!

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

    You saved my grade. The video was super clear and easy. Thank you xxx

  • @felipetobonconde5888
    @felipetobonconde5888 3 года назад

    Give this man a cookie.

  • @Perrygordo.n
    @Perrygordo.n 2 месяца назад

    Thank you 🤎🧸🧺🫧

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

    Great way of teaching

  • @getshakalu3322
    @getshakalu3322 6 месяцев назад

    Thanks best explanation

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

    thank you, best explanation.

  • @kudamuyun3173
    @kudamuyun3173 2 года назад +2

    Excellent tutorial with a great explanation. I must give 5 stars rating on this !!

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

    Thank you so much 😊👍

  • @andrehenry3212
    @andrehenry3212 6 месяцев назад

    Thank you

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

    Thank you!

  • @KamranMumtazAhmed
    @KamranMumtazAhmed 3 года назад +1

    There was no need for absolute reference in target column; I believe. Thanks for the video, it was really helpful. 🙂

    • @santiagodonald9170
      @santiagodonald9170 3 года назад

      sorry to be offtopic but does someone know a way to log back into an instagram account?
      I stupidly lost the account password. I appreciate any tips you can give me.

    • @milesben7635
      @milesben7635 3 года назад

      @Santiago Donald instablaster =)

    • @santiagodonald9170
      @santiagodonald9170 3 года назад

      @Miles Ben thanks for your reply. I got to the site through google and im trying it out now.
      Seems to take a while so I will get back to you later when my account password hopefully is recovered.

    • @santiagodonald9170
      @santiagodonald9170 3 года назад

      @Miles Ben It did the trick and I now got access to my account again. I'm so happy!
      Thanks so much, you saved my account!

    • @milesben7635
      @milesben7635 3 года назад

      @Santiago Donald You are welcome :D

  • @sudharamaprasad7518
    @sudharamaprasad7518 3 месяца назад

    Thank you so much. It was useful. Can you tell me how I can format all the series in a given graph for line colour, marker, size, etc.?

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

    Excellent tutorial.

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

    Thanks for the info sir..

  • @achilleonv
    @achilleonv 3 года назад +7

    Is this the only way to add a goal line in excel? It is so easy in other programs like Minitab, but it is a pain the butt for excel. Why do I need an entire column just for a goal line. It makes sense if the goal is moving, but if it is static for the given time frame then it should be much easier to insert. I work with data that is 6-9000 data points a day. Over the course of a month I can have 250k data points. I have had to use another column for 250k rows just to show a static goal...

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

      this is exactly my issue, it's incredibly inefficient, why cant i just use the cell at the bottom of the chart that i alread have with the average in it???

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

    Thank youuuu

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

    lovely tutorial...

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

    Thanks so much!! This makes it so easy

  • @leeannatum1727
    @leeannatum1727 3 года назад

    Thanks for the help with my homework. Wasn't sure how to show that average line until I watched this video. Thanks for the help.

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

    Thanks for the helpful video and great explanation.

  • @knowledgecentre2907
    @knowledgecentre2907 3 года назад

    very nice explaination

  • @VirendraSinghRajputGwalior
    @VirendraSinghRajputGwalior 22 дня назад

    Sir, Is it possible change the color of only those bars which has crossed target value

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

    Very well explained!

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

    Excelent! Thanks for this!!

  • @claytonryon9829
    @claytonryon9829 3 года назад

    very helpful for htis topic - the fastest and most accurate one i've seen - thank you!

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

    Brilliant. How do you make the chart independent of the table after you've created it?

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

    What if I select a few months at a time and would like the average for those. In this case depending on selection of months average value changes.

  • @arshad1781
    @arshad1781 3 года назад

    Thanks

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

    Great video, however, i'm trying to add a target line to a waterfall chart and this method doesn't seem to work, any ideas?

  • @sudharamaprasad7518
    @sudharamaprasad7518 3 месяца назад

    Correction. How to format all elements of all the series in a graph in one shot?

  • @m.akbarrizkial-fadhilah6353
    @m.akbarrizkial-fadhilah6353 3 месяца назад

    How to create it on Ms. Excel 2010?

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

    My keyboard has FN KEY which has blue color, when I try to click FN + F4 DOESN'T WORK.
    what alternative way in order to make target line

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

    This combo option is not coming on my template list?? What should I do??

  • @sereyroathchea5441
    @sereyroathchea5441 Месяц назад

    how to extend the target bar?

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

    is there a way to add a target value without adding a column to table

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

    👌🏼👌🏼

  • @labkktpl
    @labkktpl 3 года назад +2

    How to adjust/ expand the target line so that its touch the y axis

    • @barry5766
      @barry5766 3 года назад

      Did you find out how to do this?

    • @labkktpl
      @labkktpl 3 года назад

      @@barry5766 No I didnt. Pls advice, Thanks!

    • @crackedLCDsalvage
      @crackedLCDsalvage 3 года назад

      @@labkktpl @Barry you could add empty rows for the desired series on each side - so that your data series is in between these empty rows. Of course, add the threshold value in this empty row. Hope it makes sense.

    • @lewisclothier5496
      @lewisclothier5496 3 года назад

      I think you can select on tick mark in axis formatting, it makes your X axis start from 0

  • @Ro_-hk4yz
    @Ro_-hk4yz 6 месяцев назад

    When i click on combo it only gives me 3 options and i cannot choose the series?? anyone else with this problem?

  • @jannrobertson5879
    @jannrobertson5879 3 года назад

    can the target values be different amounts?

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

      Its depend on yr statistics application. I havent seen different target in the group of number or data. Coz target usually refer to specific value in the group of number.

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

    what if the target line more than one?

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

    Why not just colour one gridline?