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.

can this be done? any help would be awesome!

I've uploaded the file if anyone wants to take a look:

http://www.filefactory.com/file/26177a/

http://img142.imageshack.us/img142/5...tureou2.th.jpg