Conditional Colour Charting

  • Hi all,

    I have searched high and low (probably not hard enought tho!) for some code which will change the colour of bar charts conditionally - i.e. If the bar is above 90% it is red, if the bar is between 70 and 80% it is green etc.

    I have 50 charts which already exist and I have seen ways of performing conditional charting which does n0t involve coding - but not appropriate for this. This situation i believe will require some code because the charts are dynamic themselves...

    Has anyone got an example of some code where a bar chart is conditionally formatted?

    Thanks for any help in advance!


Participate now!

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