Conditional formating in graphs

[Angel Agosto]

I would like to know if you can apply some conditional
formatting in a graph data label. An example is if a
variable X is below a determined value Z then in the
graph the data label for variable X is in red, but if X

= Z then the data label on the chart should be in black.

Is this posible? I would appreciate any help you can
offer me.

 

[Jon Peltier]

This page has a couple examples showing how to format the individual points:

http://www.geocities.com/jonpeltier/Excel/Charts/format.html

What you might do is set up separate series, format the points the same,
but format the labels differently.

You can use a VBA approach to step through the labels, butt you will
have to rerun the macro if the data changes.

- Jon