Dynamic Chart Coloring

  • I want to build bar charts (and possible other types) where the colors of the bars are a direct function of the value being charted. For example, I'd like to build an index chart where values above 100% result in a green bar, whereas values below 100% result in a red bar. I'm useless in VBA, so any assistance would be greatly appreciated.



  • Each bar on a chart corresponds to a series.

    To do what you are trying to achieve, you may be able to incorporate some of the below code:

    Please note, this code is untested, just trying to point you into the right direction

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!