Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Customizing Oracle APEX Bar Chart Tooltip Text Colors Based on Value

sonali5 days ago

I'm working with a bar chart in Oracle APEX that displays ACB Opening and Net Churn percentages. Currently, I've implemented a custom tooltip that shows these values when hovering over chart elements:

'ACB Opening : ' ||TO_CHAR(SUM(ACB_OPENING),'99,99,99,99,99,999') ||chr(10)|| 
'Net Churn % : ' || TO_CHAR(round(((((SUM(ACB_CLOSING)-(sum(NC_MTD)))- SUM(ACB_OPENING)) / SUM(ACB_OPENING))*100),2), '99999999900.99') || '%' as tooltip

Current Implementation:

  • The tooltip successfully displays the values
  • The formatting works as expected
  • Values display in default color (black)

Desired Implementation:

  • I want the ACB Opening and Net Churn values to display in:
    • Red color when negative

    • Green color when positive

      Is it possible to apply conditional formatting to specific parts of a tooltip in Oracle APEX charts? If so, what's the recommended approach?

This post has been answered by Oleh Tyshchenko on Apr 7 2025
Jump to Answer

Comments

Processing

Post Details