Chart with 2 series and 2 colors for each series

[nelkin]

Hello,
I have a chart that called "X Y Scatter with only markers".
First line should be marked with 2 colors, one for "above 0.5" and one for "below 0.5"
Second line should be marked with 2 colors also, one for "above 0.1" and one for "below 0.1".

Please your help, been racking my brains trying to find an automated solution and paint each point manually.

Thank you!
Nelly.

[Andy Pope]

you can probably use multiple series based on formula.

bit confused by 'marker only' chart and your description of first and second Line.

if you need more help post example workbook to clarify