Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Color code columns in bar chart based on a y- axis criteria


I have a table of data based on which we have inserted a simple bar chart but the colors needs to be changed dynamically based on the criteria2 given beside just like conditional formattiing.

Is this possible?



Selected Answer

Dr Liss

Please see my recent answer here: Can a chart bar color be based on conditional format color? which gives an approach you can modify.

Hope that helps



Did you try that?
John_Ru (rep: 5147) Aug 2, '22 at 4:21 am
Hi John_Ru,

Yes, I was able to create the chart easily. I guess I had a relatively easier problem statement.

Thanks for your help!
Dr Liss (rep: 26) Aug 4, '22 at 4:19 am
Glad that helped you. Thanks for selecting my Answer.
John_Ru (rep: 5147) Aug 4, '22 at 4:21 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login