Have a look at
http://peltiertech.com/Excel/Charts/...nalChart1.html
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"JFolsom" wrote in message
...
Hi,

I'm trying to make a line graph for 203 subjects with 3 data points.
I would like to color code the individual line based on another
variable. I want 203 lines, but only 4 colors. Is there some way to
do this without manually changing each individual line?

Thanks for your help!
Jessica