On Wed, 27 Feb 2008, in microsoft.public.excel.charting,
Sapster86 said:

Hi i'm using excel 2007 (SP1) just wondering is there a way to automatically
assign a different colour to points depending on the difference between the
results on both axises?

The data i'm using is a set of elevations from two different sources that
show the error in an elevation model. I need to ideally make points that say
have a differnce of <50cm from perfect corelation appear a differnt colour to
those which are for example <25cm.

For just a few colours, the solution is relatively easy. Create a new
series using the formula

if difference < 50cm, value, NA()

Create as many series as you need to produce the effect.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.