Scatter plot data points customization

[etamer]

I have created a scatter plot based off of two variables. There is a third categorical variable (results in either 0 or 1) that I need to include in the data point. When the categorical variable is 1 I want the data point to appear red. When the categorical variable is 0 I want the data point to be blue. Any suggestions?

[#2]

Create two separate series for the chart by adding two columns, 1 for the 0's and one for the 1's. Use a formula like this one to get the data from column B (column C contains the 0's and 1's):
=IF(C2=0,B2,NA())
and the other new column:
=IF(C2=1,B2,NA())
Now use these two columns for Y-values, replacing the original one. This enables you to set a separate color for each of them.