Color points according to a third value

It's not easy to answer such a general question :)

The general answer is Yes.

Use the SetColor command and an If command into it to define the conditions.

Move the slider in the attached file and have a look to the color of point A.

Check the UnUpdate script for the slider.

option 1 is what SImona used: fixed colors between set margins of e.g. a slider or a coordinate of a point

option 2 is to use dynamic colors in which the change of colors is dynamic.

In this example it will shift from red to blue.

So the 'right' answer to you question just depends on what you want to do, which is not clear in your question

chris

Create the points in the spreadsheet with relative addressing as following:

1) create in F2 the point-command: (A2,D2)

2) mark F2 and show object-properties / advanced

3) change as the following picture (for F2)

.

Note: (C2 - minExp) / (maxExp - minExp) produce a value between 0 and 1 for experience-color

This is one of several possibilities (education (B2) could be used as well)

.

4) mark F2 and hold with the left mouse-key the black square-point at bottom right (on F2)

5) move the mouse down until F50 (with the holded left mouse-key)

note: in cell F3 the point is change to (A3,D3) and in the properties C2 is chang to C3 etc.

this causes so-called relative addressing

6) mark columne F change point-size and show-label off

The above result must be same as in the attachment

improved with a color-function.

The function is calculated in column G and used in properties/advanced in column F

Excellent :-)

The second plot is the best.

I will work on with an RGB translation of experience/education.

Regards

Olav