topic Re: Assign individual colors to multiple lines in a chart in App Development

Assign individual colors to multiple lines in a chart

ffanary — Sat, 16 Nov 2024 17:35:15 GMT

I have a line chart that has multiple lines. I need to assign each line a specific color. I have gone to "Custom: Colors & Legend" then chose "Expression" . In Expression I wrote:

If(Sum([Sales Actuals])>'0', RGB(59, 147, 65)) ,

If (Sum([Cost Actuals])>'0', RGB(200, 17, 165)) ,

If (Sum([Sales Planned])>'0', RGB(156, 100, 105)) ,

If (Sum([Cost Planned])>'0', RGB(250, 15, 75)) ,

If (Sum([Total])>'0', RGB(24, 60, 200))

What is the correct syntax to assign each measure its own color? Or how can I assign each measure its own color?

Re: Assign individual colors to multiple lines in a chart

Anil_Babu_Samineni — Fri, 22 Jan 2021 17:38:11 GMT

You are closing conditions immediately to the IF where as it required in the end, like

If(Sum([Sales Actuals])>'0', RGB(59, 147, 65), If (Sum([Cost Actuals])>'0', RGB(200, 17, 165),

If (Sum([Sales Planned])>'0', RGB(156, 100, 105), If (Sum([Cost Planned])>'0', RGB(250, 15, 75),

If (Sum([Total])>'0', RGB(24, 60, 200))))))

Re: Assign individual colors to multiple lines in a chart

ffanary — Fri, 22 Jan 2021 17:41:56 GMT

Thanks!!!! That worked.