Assigning the same color to a line as expression in chart

[#1]

I have a sheet which contains a chart and a line.

The chart has multiple expressions in a single dimension.

I am trying to assign the color of one of the chart expressions to the line object. It should be done dynamically, for example, if color for chart expression changes, line color should be changed as well and get the same. I know the color for the line object can be assigned as calculated but I do not know how to refer to chart expression color in order to get it from there. So how to get rid of this?

[migueldelval]

Hi Tony,

Try something like that:

=If(fruits=''orange', rgb(0,0,0), if(fruits='lemosn', rgb(1,0,0),If(....))

If you send me your fields and values I could make the conditional expression for you.

Regards

Miguel del Valle