Yes, in that case you can add another column next to "At or Above 65" with a new condition that you define. Now you have three conditional values, make sure to make them mutually exclusieve. Exactly one condition must be true, the others must be NA(). You can repeat this process as many times as you want.
Thanks for your question. There is a good answer above from @Gapiedaan. Also, I created a new video that demonstrates how to do this: ua-cam.com/video/4JCjZLLzBXI/v-deo.html (How to create a Bar Chart with Color Ranges based on Numeric Value in Excel) - and it has in the description an Excel file you can download to see the formulas and chart. I hope this helps! - Catherine
This is very cool, but is there a way to have multiple colours based on value please?
Yes, in that case you can add another column next to "At or Above 65" with a new condition that you define. Now you have three conditional values, make sure to make them mutually exclusieve. Exactly one condition must be true, the others must be NA(). You can repeat this process as many times as you want.
Thanks for your question. There is a good answer above from @Gapiedaan. Also, I created a new video that demonstrates how to do this: ua-cam.com/video/4JCjZLLzBXI/v-deo.html (How to create a Bar Chart with Color Ranges based on Numeric Value in Excel) - and it has in the description an Excel file you can download to see the formulas and chart.
I hope this helps! - Catherine
@@Gapiedaan Thanks for providing this clear and well-written answer! 🙂 - Catherine
Thank you so much! I really enjoy your videos and look forward to seeing more. Keep up the great work
Thank you for such a nice comment! I really appreciate it. - Catherine
brilliant, this is so different
Thank you for your kind comment! - Catherine
Nice but Pound N/A..... LMAO 😂 since when did hash became a pound 🤪
LOL! That's what we called it way back when. 🤣- Catherine