Forum Discussion

etamer's avatar
etamer
Copper Contributor
May 26, 2019

Scatter plot data points customization

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?

Charting
excel
Excel on Mac
Excel Online
Formulas and Functions
office 365

1 Reply

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    May 27, 2019
    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.

Resources