Linking to a chart within an expression

[#1]

Hi I am querying whether it is possible to link a the third column of a chart into an expression on a different sheet

[Gysbert_Wassenaar]

No, that's not possible. You could use a variable to store the expression and use the variable in both charts.

For example:

variable v_Expr: sum(Sales) 

Expression in chart one: $(v_Expr)

Expression in chart two $(v_Expr)*12

[#3]

Hi I tried that already please see below:

the last column should display the same as the column that has certain cells highlighted green but it doesnt work for some reason