i plot line charts for the growth trends of top product brands..i want to
have the same color of the line for a particular brand in all the charts i
create...so i need a macro to have a fixed color for the series based on the
series name, so that i do not have to format each and every line of every
chart, which is very time consuming as i have to do some 50 charts..

i am using excel 2003