Hello,

I'm completely new to VBA, but I didn't find a solution for this yet.

I want to do the following:

I have a table which shows a value to certain terms, let's say the title is "Sold kg per month", and they values are: "Strawberrys"=> 50, "Apples=> "60".

This table is shown via VBA as a bar chart. How can assign fixed colors to the terms, so that the bar for "Strawberrys" is always red, and the Apples are always green? The order of the rows can always be different.

I hope someone her can help me?

Greetings

Thomas