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