SOLVED

How do I get individual points to be specific colours on scatter graphs?

%3CLINGO-SUB%20id%3D%22lingo-sub-2393151%22%20slang%3D%22en-US%22%3EHow%20do%20I%20get%20individual%20points%20to%20be%20specific%20colours%20on%20scatter%20graphs%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2393151%22%20slang%3D%22en-US%22%3E%3CP%3EEssentially%20I%20would%20love%20to%20know%20how%20to%20achieve%20a%20scatter%20graph%20like%20this%20with%20conditions%20for%20the%20colour%20of%20points%20depending%20on%20the%20number.%20E.G%2045%20-%2065%20is%20Light%20Green%20etc%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20for%20any%20help%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%20(269).png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F284366i86FB09A138289CB7%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%20(269).png%22%20alt%3D%22Screenshot%20(269).png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2393151%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2393182%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20get%20individual%20points%20to%20be%20specific%20colours%20on%20scatter%20graphs%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2393182%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1065081%22%20target%3D%22_blank%22%3E%40JKelliher%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOne%20way%20to%20do%20this%20is%20to%20create%20a%20separate%20series%20for%20each%20range%20of%20values.%3C%2FP%3E%0A%3CP%3ESo%20in%20your%20example.%20all%20values%20in%20the%20range%2045-65%20should%20be%20in%20a%20column%20of%20their%20own%20(or%20row%2C%20depending%20on%20your%20data%20layout)%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0455.png%22%20style%3D%22width%3A%20923px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F284370i5DE1C5CD9E9C10E6%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22S0455.png%22%20alt%3D%22S0455.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Essentially I would love to know how to achieve a scatter graph like this with conditions for the colour of points depending on the number. E.G 45 - 65 is Light Green etc

Thanks for any helpScreenshot (269).png

1 Reply
best response confirmed by JKelliher (Occasional Visitor)
Solution

@JKelliher 

One way to do this is to create a separate series for each range of values.

So in your example. all values in the range 45-65 should be in a column of their own (or row, depending on your data layout)

S0455.png