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?
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.)
Color code columns in bar chart based on a y- axis criteria
0
Answers
0
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
Discussion
Did you try that?
John_Ru (rep: 6142) 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!
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: 6142) Aug 4, '22 at 4:21 am