Dynamically change each bar color based on a variable

[harwarj]

Hi,

I have a graph that one axis is volume (bar graph) and the other is premiums (line graph). I want to apply a shading to the bars (volume) to represent a mix of volumes coming from two different locations which will be held within excel.

Any ideas?