Bar Graph specifying Gradient fill colors

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?

Hi CoreyTroy,

You can do this, but your post is a little confusing.

You talk about gradient fill and also about solid fills.

Please check out these tutorials and see if it helps.

This one will show you how to group your stacked bars together:
How-to Easily Create a Stacked Clustered Column Chart in Excel

This one will show you how to make your data points (blocks in the column/bar chart) different colors based on formulas in your spreadsheet:
How-to Make a Conditional Column Chart in Excel

Each has a detailed step by step tutorial as well as a video tutorial.

Please let me know if this helps.

Steve=True