Thread: Filter the way data is plotted

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?
--
Regards
Lars

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.

"Lars" wrote:

> 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?
> --
> Regards
> Lars

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

http://www.peltiertech.com/Excel/Cha...html#CondChart

Lars wrote:
> 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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Lars,

This example might help:

http://www.pdbook.com/index.php/exce...scatter_chart/

----------------------------
Regards,
John Mansfield
http://www.pdbook.com


"Lars" wrote:

> 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?
> --
> Regards
> Lars