Excel area chart with positive / negative colors

Поділитися
Вставка
  • Опубліковано 19 сер 2024

КОМЕНТАРІ • 16

  • @moosemaan4320
    @moosemaan4320 Місяць тому

    Love you intimately for this

  • @mansijswarnkar4389
    @mansijswarnkar4389 2 роки тому

    Thank you for sharing this, I was actully searching for this kind of graph, many many thanks !

    • @chandoo_
      @chandoo_  2 роки тому

      Glad it was helpful!

  • @wayneedmondson1065
    @wayneedmondson1065 4 роки тому +1

    Hi Chandoo.. interesting chart and technique. Thanks for sharing it. Thumbs up!!

    • @chandoo_
      @chandoo_  4 роки тому +1

      Thank you! Cheers!

  • @MrAdrianchung
    @MrAdrianchung 4 роки тому

    Thanks bro!u saved my dissertation!

  • @ch0c0holic
    @ch0c0holic 4 роки тому

    Thank you! Great tip or tips actually, because I didn't know how to do it on the bar chart as well. Keep up the good work.

    • @chandoo_
      @chandoo_  4 роки тому +1

      Glad it was helpful!

  • @RMDareGreatly
    @RMDareGreatly Рік тому

    Thank you!

  • @MustafaAhmed-mb7hu
    @MustafaAhmed-mb7hu 4 роки тому

    Gr8 job...u r truly innovative....is there a way to display specific values on chart with mouse hover (if mouse is placed over a chart it displays or highlights the values)

  • @lucasritter8768
    @lucasritter8768 2 роки тому

    I can’t figure out how to change the base line!! My area chart just fills in everything below the line

  • @thevidhan
    @thevidhan 3 роки тому

    Other way to do this kind of colour chart is separate the negative observation in the next column and than replot the same, with both columns included.

    • @chandoo_
      @chandoo_  3 роки тому

      Can you actually try this and let us know if the results match? I am under the impression that the _lines_ won't align with this approach.

    • @thevidhan
      @thevidhan 3 роки тому

      @@chandoo_ if I can have your email, will be happy to share the sample working.

  • @Surya_jain
    @Surya_jain Рік тому

    Can't we get simple line instead of area ?