Filter the way data is plotted

[Lars]

I have series of data that plots in a XY diagram. Is there a way to change
colour of the points plotted if a certain value is below a set value? e.g.
one point turn red if A1 < 5?

 

[bj]

You can use two data series one for above your critical point and one for below
you can also select individual points and chage just the color of that point
if there are only going to be a few points of interest.

 

[Debra Dalgleish]

Jon Peltier has instructions for conditional charts that you could adapt
to your workbook:

http://www.peltiertech.com/Excel/Charts/format.html#CondChart

 

[John Mansfield]

Lars,

This example might help:

http://www.pdbook.com/index.php/excel/conditional_point_formatting_xy_scatter_chart/