John -

See my conditional charting page:

http://peltiertech.com/Excel/Charts/...nalChart1.html

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


"John" wrote in message
...
I run 30 quarterly reports and graph 3-5 measures on one chart. Each
measure
includes five column charts: four for the quarterly results, and a fifth
bar
chart for the benchmark (formatted to overlap the quarterly results 100%
it
forms a box around them). Finally, a line chart containing ONLY markers
for
the YTD results. I would like the marker or at least the color of the
marker
to change when the YTD result that is represents is less than the
benchmark
it is being measured against.

Anyone have any suggestions on how to accomplish this?

Thanks in advance.