I want to perform some simple formatting for a bar graph in Oracle Apex. In a numerical graph, given a value, I want to draw a horizontal line across the y axis at that value and any bars that contain values below that line should be coloured red and otherwise green. For example, if this is my [Bar Graph] and the value inputted is 33, only one bar should be green and the others red

I am not sure what to try, my graph source is an SQL Query and I know there may be some solutions that use the CASE query in connection with some CSS, but I am unsure about how to go about this. I appreciate any solution.