Coloring depending on the Series

[utsvulten]

Hi,
Im looking for a VBA script that can color the series in a chart depending on the name of the series. So if i have two or more charts and the name of a serie occurs in both, they get the same color.
Is this possible?

For example say I have one chart where I logg runners time on 100 meter. Then I also have a chart where I logg runners time on 200 meter. The scrips should give a runner the same series color if he/she exists in both of the charts.

PS I use Excel 2007 DS

Thanks in advance

[Mis_Sailesh]

Please see if the following link is helpful for you:-

http://peltiertech.com/WordPress/vba-conditional-formatting-of-charts-by-series-name/

:help