A color for each of the bar

Hi,
I am recording a macro to generate a excel graph from a table as show below. Everything works fine. I need to use this code for automation purpose.

However the bar graph generated has only one color which is the default color blue. Is there any way for each of the four bars I can assign a color for each type of category

eg Total Green color, C/C Blue, CAR Yello and SCAR Gray.
I appreciate any help for resolution of this issue. Thanks

Please Login or Register  to view this content.

CategoryCount
Total 44
C/C 17
CAR 12
SCAR 15