Charts - Colours

3283263

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

Pedro F

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.

3283263

Hi Pedro,

I cannot find where to set a conditional formatting for the chart. How do you do that?

Pedro F

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.

3283263

Hi Pedro,

Unfortunately, I think in the CRM I do not have such an option: I have checked everywhere.

Any alternative?

Joel

Hi @3283263

A quick way to get round this would be to slightly modify the column formula of your 3 measures.

Use the formula IFNULL (expression, 0) to force the column to always have a value and NULL values will be represented with a zero.