Hints and Tips - How to Control the Colours in a Graph

Summary

Explanation of how to drive the colours in your graphs by the values being displayed

Content

This is part of a series of sample reports created by Oracle BI and HCM Product Management. You can copy the setup for this report and add it to your Oracle HCM Cloud Service environment.

You may have noticed that when you create a chart, the colours shown depend on the number of values being displayed. So the first value is blue by default, the second red, the third lilac etc. That is fine if you only have one page on a graph, but if you add a slider or a drop down to create multiple “pages” of information, the same value may show as different colours on different “pages” because of its different relative position on that “page”. So, for example, a value may be blue on one page (where it is the first