Change colour on chart - Dictionary Type = Reference

[gustattmann]

I would like to change the colors of different reports to make it for the user better to understand. My example - Value Country 2 is always defined with color 2 on the x axle.

I know that I can define colour chart here: 

However, what should I do if the dictionary Entry is Type Reference and not Choice. I can not define the value of the and the color set up on the table Syst_report_chart_colour. How can I fix this: 

County 2 should always be color 2 but in depending on which position the value is.  

[Yashsvi · Accepted solution]

Hi @gustattmann,

please check below link:

https://www.servicenow.com/community/itsm-forum/chart-colors/m-p/636090

Thank you, please make helpful if you accept the solution.

[gustattmann]

Thanks you very much - this link was very helpful. to use the Sys_id to define the color on the chart.