Forum Discussion
scatter chart conditional color code
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
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
3 Replies
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