In chart an option is missed, you can set a fixed value X, so the part of the value that exceed this value X is highlighted in any way.
Created attachment 76946 [details]
Example 1 with a line for a fixed value
Created attachment 76947 [details]
Example 2 with sparately coloured columns
Created attachment 76948 [details]
Example 3 with coloured wall
I added thee different examples how it could look like.
Thanks for the clear examples. I am confirming this bug. Status set to NEW. Version set to Inherited From OOo as this feature has never existing in LO. Severity set to enhancement.
This enhancement would seem to require extending the ODF v1.2 specification, perhaps by including a new element to define the upper bound area e.g., <chart:upper-bound-value> that is somewhat similar to <chart:mean-value>.