this posting is a slight modificationof a posting in the newsgroup
See the sample sheet below.
Notice the formulas in column C
Choose in the second step chart wizard “series”(in the first step you have chosen scatter chart)
Cilick add and reference x values as A2 to A8 and y values as B2 to b8
Click again add and reference x values as A2 to A8 and y values as C2 to C8
The chart is designed to show points y values above 5 in red(defailt)
You right click the red point and click format data series and change MARKER style and foreground foreground color
You modify the formula in column C and modify the chart as required. By you.