Fixed value in XY chart and color change based on value


i have an XY Chart where the serie is rendered as column. I want to add a line with the “target” for the columns, based on a fixed value (ex. 50). I thought to insert a new serie with a fixed value for each column, this could work?

If i want to change the color of the column based on the fixed value (below in red, else blue), i can make it possible by scripting on the valuechanging of the column serie?

Thanks for all the suggestions :slight_smile: