Excel Chart Element Color

Copper Contributor

is it possible to "program" the value of a chart element Color rather than manually changing each chart column and its Color? ("Program" based on a value in a table)

In this example the Color is set by the Org Code

 

OscarTrimboli_0-1650611843668.png

 

1 Reply

@OscarTrimboli 

See the attached sample workbook. The VBA code could be generalized of course.