VBA coloring columns in chart

[Dimitris254]

i have several clustered column charts that i'm struggling to color them in a specific way

so, the default Excel colors look something like that: http://i.imgur.com/rBL3vBi.jpg
what i want is this: http://i.imgur.com/rAZDzGv.jpg
the table is this (ploted by columns in the macro): http://i.imgur.com/SjqlEJO.jpg

right now, in order to go from default to desired format, i have to click every single data point > fill color, which, needless to say, is a pain..

any help would be highly appreciated

 

[Worf]

Your example chart has nine series, and the data table has nine rows. However, each of the three groups uses a different colour.
How would you like to do it?