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!


    Dani

Participate now!

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