You could adapt this approach:

VBA Conditional Formatting of Charts by Series Name
http://peltiertech.com/WordPress/vba...y-series-name/

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



brewer wrote:
I am building several line graphs for 9 customers. Is there a way to assign
a color for the data by customer without manually adjusting the line for each
customer in each line graph?