• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Change chart colour based on value in another cell

W

williamramage

New Member
Hi, I'm looking to see if it's possible to change the colour of chart entries if a cell not in the chart contains pass or fail. i.e. values will be coloured Green if the uncharted cell says "Pass" and Red if the cell contains anything else.
 
SOLVED
Used a formula to create a second series that is either empty if pass, or the value if anything else. Then added this to the chart and used overlay series option to overlay the original data set
 
You must log in or register to reply here.
Back
Top