Stacked Area Chart Series Colour Change

[downunderthunder]

hi

I have a stacked area chart located on its own individual worksheet. I would like to use VBA to apply colours to individual series based on the name of that series. I have applied the following code which I found on the following help forum, changing it slightly to fit my needs: http://www.ozgrid.com/forum/showthread.php?t=91381

Please Login or Register  to view this content.

Can some one please identify the problem with this code as it doesnt cause any change in the chart

cheers

DUT

[pr4t3ek]

are you able to post an example workbook?

[downunderthunder]

unfortunatly no the data is somewhat confidential

[downunderthunder]

I figured it out myself

Please Login or Register  to view this content.