Color each Bar in a Bar Chart based on Interior Celll Color

Hi guys,

i created a bar chart based on data which is located on the same sheet. I can also colorize each bar individualy based on the according cell interior color.
BUT the color of the cells and the bars are not the same. I think i use color-index to get cell color and colorize bars with rgb-color.

How can i get the same colors on bars as in the cells of my sheet.
In the attachment you can find a working chart with the wrong colors on bars.
Please have a look.
Thanks.

Please look at the attachment, thanks

try this to get the correct green columns.

Please Login or Register  to view this content.