Hi I am querying whether it is possible to link a the third column of a chart into an expression on a different sheet
No, that's not possible. You could use a variable to store the expression and use the variable in both charts.
variable v_Expr: sum(Sales)
Expression in chart one: $(v_Expr)
Expression in chart two $(v_Expr)*12
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
Retrieving data ...