I have a stacked collumn chart and i would like to be able to change the
colour of the individual series depenind on the series name i.e. if the title
of series 1 = "fred" then change the colour to red, I have seen some
variations around the theme in the newsgroup but can't quite the the
SeriesCollection method to work can anyone help.

Thanks DK