Andy Pope has an example like this on his web site:

http://andypope.info/charts/conditionalline.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"JB12" wrote in message
...
I have a chart where the average of the coporation as a whole is used as a
benchmark and then from a drop down list you can select an entity you want
to
compare to the benchmark. I am hoping to have the line of the entity
change
colors (i.e. from solid black to solid red) if it exceeds the benchmark
line.
Is this possible?