Color Bar Representation

[BillGulledge]

I want to create a horizontal bar chart -- with one bar and stacked values, based on the values in a cell range. For example, I have entered numerical values in 3 cells -- A1 through A3 as follows:
A1 = 5
A2 = 3
A3 = 17


With this example, what I want to create is a one bar horizontal bar chart with three sections -- the leftmost section would be 5 units wide, the middle section would be 3 units wide and the right section would be 17 units wide. The total length of the bar would be 25 units.
If I change the values in A1 through A3, the sizes of the bar sections in the chart would change accordingly.

(The solution should accommodate a cell range with up to 10 cells, though only three are used in this example.)


To make it a little more useful to me, I need to be able to assign colors to each section of the bar chart -- for example the section representing A1 might be blue, the section representing A2 might be yellow, etc.

The easiest for me would be to color each of the cells containing the values for A1, A2, A3 with the desired color, and let the chart pick up the colors from the colors in A1:A3 but this may not be the easiest way to get the colors in the chart.
I am a fair had with Excel but don't do much with charting so this is beyond me.
Thanks
Bill

 

[Steve=True]

Hi BillGulledge,

This sounds a lot like the following posts.

Here is what it was based on:
friday-challenge-pipeline-usage-chart

Here is a VBA solution:
match-product-chart-colors-to-excel-spreadsheet-cells-petes-vba-solution

Other solutions:
leonids-friday-challenge-answer-pipeline-usage-stacked-bar-chart

pipeline-usage-chart-dons-answer

pipeline-challenge-matching-stacked-bar-chart-colors-to-products-without-vba


Let me know if this was what you were looking to do.

Steve=True