Can you share the workbook?
Your color is not based on values so it needs new calculation field.
forgive me, but i cant share the workbook because of sensitive Data :-(
I have only five columns
1st one is the Name of the Cell
2nd one is an Product name
and the 3rd one is a column with Numbers "from null to 542"
the other 2 columns are X and Y axies
the color gradient should not be shown with fixed values, but with dynamic once. In your example you have one color for one value but my usecase needs to have the color gradient for a dynamic range of values
Today the range from 1-10 can be green
But tomorrow the range from 1-10 can be yellow
Only the value "0" should have a fixed color.
The conversion from null to 0 is already done with the formula "IFNULL"
in your example the color for null/0 is not customized.
1 of 1 people found this helpful
Another way is to use discrete, and set color for each value.
In the following picture, I set blue for 0 and orange gradual change for other values.
You can select all values and click assign palette instead of assign one by one.
If this posts assists in resolving the question, please mark it helpful or as the ' correct answer' if it resolves the question.