Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Charts - Colours
Hi All,
I have an issue for setting colours in my chart (first picture below). This chart contains 3 criteria in the legend: Minor, Intermediate and Major. I have set up in the 'Format Chart Data' window (second picture below) to have Major in red, Intermediate in orange and Minor in Green.
But when I get only the criteria Minor, the colour for Minor will be red instead of green because the Format Chart Data is set up by order of appearance.
My question: can we set up the legend colour by criteria instead of the appearance order?
Thank you very much for your help
Answers
-
Hi,
Why don't you create a conditional formatting for the chart where you have something like: <10 color=red (major); >=10 and <20 color= orange (intermediate); >=20 green (minor) and then just create a new Legend view with those definitions and put next to the chart.
Otherwise, if you define colours by the bar positions, it will assume the colours by order so if you only have minor, all bars will be red and not green.
0 -
Hi Pedro,
I cannot find where to set a conditional formatting for the chart. How do you do that?
0 -
If you're editing a chart, go to "Graph properties" -> "Style" (2nd tab) -> "Style and Conditional Formatting" -> "Conditional Formatting" (2nd tab) and then create the conditional formatting you want.
0 -
Hi Pedro,
Unfortunately, I think in the CRM I do not have such an option: I have checked everywhere.
Any alternative?
0
