Home

Scatter plot data points customization

%3CLINGO-SUB%20id%3D%22lingo-sub-648973%22%20slang%3D%22en-US%22%3EScatter%20plot%20data%20points%20customization%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-648973%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20scatter%20plot%20based%20off%20of%20two%20variables.%20There%20is%20a%20third%20categorical%20variable%20(results%20in%20either%200%20or%201)%20that%20I%20need%20to%20include%20in%20the%20data%20point.%20When%20the%20categorical%20variable%20is%201%20I%20want%20the%20data%20point%20to%20appear%20red.%20When%20the%20categorical%20variable%20is%200%20I%20want%20the%20data%20point%20to%20be%20blue.%20Any%20suggestions%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-648973%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-650571%22%20slang%3D%22en-US%22%3ERe%3A%20Scatter%20plot%20data%20points%20customization%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-650571%22%20slang%3D%22en-US%22%3ECreate%20two%20separate%20series%20for%20the%20chart%20by%20adding%20two%20columns%2C%201%20for%20the%200's%20and%20one%20for%20the%201's.%20Use%20a%20formula%20like%20this%20one%20to%20get%20the%20data%20from%20column%20B%20(column%20C%20contains%20the%200's%20and%201's)%3A%3CBR%20%2F%3E%3DIF(C2%3D0%2CB2%2CNA())%3CBR%20%2F%3Eand%20the%20other%20new%20column%3A%3CBR%20%2F%3E%3DIF(C2%3D1%2CB2%2CNA())%3CBR%20%2F%3ENow%20use%20these%20two%20columns%20for%20Y-values%2C%20replacing%20the%20original%20one.%20This%20enables%20you%20to%20set%20a%20separate%20color%20for%20each%20of%20them.%3C%2FLINGO-BODY%3E
Highlighted
etamer
New Contributor

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?

1 Reply
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.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies