scatter chart conditional color code

[Anonymous]

Hello, 

I could not find any insight on how to have a scatter chat with conditional colour. 
My graph below needs to show the colour code of the data points as follows:
planned maintenance PV 30 over 30,000 red
planned maintenance PV 30 over 15,000 - 29,999 amber
planned maintenance PV 30 less than 15,000 green

Do I have to create a calculated column for this? I thought about creating a group but it's impossible given the number of unique values.

Many many thanks!

R

[Pragati11 · Accepted solution]

Hi @Anonymous ,

You can create conditional formatting on the scatter chart by using Data Colors option under formatting.

Once you click on the function icon, a new window appears, where you can create your custom rules as defined above:

• Format style choose Rules
• what field should be used choose planned maintenance PV 30 along with an aggregation that you have on scatter chart
• under Rules section, write all the rules that you mentioned above for colors

[Anonymous]

Thank you so much @Pragati11  I wasn't aware of that. 

[Pragati11]

Hi @Anonymous ,

Glad that the solution helped 🙂