Change colour of chart series

hey

I'm attempting to write a code that will change the colour of a series in a chart based on the name of each series.

i.e. I have Roads, Water and Rail as three of my series names. can i somehow assign the colours yellow, blue and red to these series using macro code.

Thanks Heaps

Perhaps this can be a start you can adapt to your workbook. This assumes a chart object in the worksheet as opposed to a Chart Sheet.

Please Login or Register  to view this content.

You could run the code by using the worksheet change event to call it. Thus, by entering numeric values in cells, automatically change the color. See cells I1:I3 in the attached.

Please Login or Register  to view this content.

Hi

This is not quite what I'm looking for.

I have applied the following code to change the colours on pie charts:

Please Login or Register  to view this content.

I would like to apply somethin similar to a 'Stacked Area' Chart

Cheers

DUT

p.s. sorry I don't know how to add specific windows in my message for the code