Progress Bar in Excel | A Conditionally Formatted Donut Chart

Поделиться
HTML-код
  • Опубликовано: 21 авг 2024
  • Excel doesn't support conditional formatting of charts natively. That's annoying. So if you want a big "tick" to say someone has successfully completed something, you might need to make concessions with its formatting or do a little more work.
    There are a few other ways of doing this, I might suggest doing the logical statement in a separate cell, and referencing that in the IF statements, but it's not going to break anything doing it this way (you write code for yourself, not the computer, remember...).
    It also invites an extension where you can show the numerical progress inside the donut, or having multiple icons appear inside the bar based on other conditions. I'll leave that one as an exercise for the reader, but it's certainly possible.

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

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

    I made a goal this year to get a better understanding of how to use excel and these videos are really helpful, just need to get into the logic mindset for writing the equations.

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

      I tend to throw stuff up randomly as it occurs to me, but if anything might be useful, I suppose I could do requests.