First time posting, not strong at all with VBA or Macros. Cannot find this answer anywhere: trying to produce a bar chart of Suppliers and their associated Spend, where the fill color of the generated bar chart matches that of the strategy (Growing = green, sustaining = yellow, bad/exit = red). I need to be able to either have the fill color change automatically (VBA) or through a whole series of hidden fields that do the calculations.
I've posted a picture that shows exactly what I want as the output. I did the coloring within the chart manually of course, but in reality I will have 1000 "suppliers" and the "Strategy" could change at anytime - a field populated by a widespread team. I can use conditional formatting well, which is what I used to manipulate the cell color shown in the "strategy" column C. However, I have no idea how to connect that color (Column C) to the graph where I want the Supplier/Spend data displayed to match in color (Red, Green, or Yellow).

If someone could generate the VBA formula (less preferred), or walk me through an idea how to generate a chart based on the 3 intended colors (more preferred), I would greatly appreciate the support!

ScreenShot116.jpg