Jon tell how to do this 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


"Cow Girl" wrote in message
...
I have a line graph that covers Jan - Dec with 4 different series of data.
I'd like to change the color of either the line and/or the marker for each
month and series depending on if the data for that month is "closed/final"
or
not.

Is there a way to change the color based on the month and not the actual
data?

Thanks!!
Cathy