Lets say I have a Scatter plot, x axis from 0 to 100, y axis from 0 to 50.
Now all values below x:10 y:10 should be green, all below x:60 y:30 should be yellow and all above should be red.
How do I do this?
Lets say I have a Scatter plot, x axis from 0 to 100, y axis from 0 to 50.
Now all values below x:10 y:10 should be green, all below x:60 y:30 should be yellow and all above should be red.
How do I do this?
Hi @maxweissboeck,
You can use chart conditional formatting to color the range of values on the scatter chart. If you would like to compare the value range for two parameters, a custom formula with regular expression could be the correct method. Please see the documentation for more details and several examples: Charts conditional formatting.
For inspiration, on the eazyBI Demo account is a collection of report examples with conditional formatting:Customized Charts - Jira Demo - eazyBI.
Best,
Zane / support@eazyBI.com
Thanks for responding!
But the chart conditional formatting for color is not available in the scatter Chart, thats why I’m asking.
It is available for Bar Charts
But not for Scatter Charts
What do I miss?
Conditional formatting is supported for Bar, Line, and Timeline chart options. For those charts, you can choose data visualization type as scatter or bubble.
On the other hand, if you switch to the Scatter chart type, conditional cell formatting is not available.
More details are described here: Charts conditional formatting.
If you can modify the report for representation on Bar chart, then you can apply condition formation there.
Best,
Zane / support@eazyBI.com
Ok, thanks for clarification
Displaying as Bar Chart is not possible, there are too many Values to be displayed and the Bar Chart also gives not the visual insights we need.
It would be very helpful if the same colouring schema that exists for Tables is also available for Scatter Chart.
For the Table we use this color cell formatting
Thats who the Table looks like
But we need a Scatter Chart of this, to understand the meaning of the data
So please, please can you support colouring of Scatter Chart at along the X and Y values in the same way as it is done for Tables?
Thank you very much!
Max
@maxweissboeck, thank you for more details.
I added a new feature request to support conditional formatting also in Scatter chart view and added your use case to it. I can not give any estimates of when this could be available, will post an update in this community post.
Thanks for the idea!
Any news on this? I still have the problem.
Hi @maxweissboeck,
The feature to color scatter chart is still on the backlog, and we listen to if there is any interest from the customers. Only a few people have shown any interest so far, and it is not on our roadmap giving place to other improvements.
Best,
Zane / support@eazyBI.com