Bar Graph specifying Gradient fill colors

[coreytroy]

I have a basic Bar Chart(100% Stacked 3D) that i have up to 10 segments.

I am trying to programatically shade each segment into a Gradient fill(top & bottom).

I can manually set the colors, but how can i set what each segment color is by a cell value?

The attached image is what the end result may look like, but i want the colors to be selected by a value from a cell.

Is this possible?

If not can i select the solid fill color and add a 2nd bar directly under the other with its solid fill colors set also by a cell value?