1 expression to be added in many chart objects in a single tab

[#1]

Hi all,

I have an expression which i have to add to 9 charts.All charts are in single tab. please tell me the way where if i add expression in 1 chart; it will be reflected in all chart objects in that tab

[Gysbert_Wassenaar · Accepted solution]

Create a variable in the variable editor and enter the expression as value for the variable. Then use the variable in each chart. For example:

Original expression: sum(Sales)

Variable vSum: sum(Sales)

Chart expressions using the variable: =$(vSum)

If you then change the variable vSum in for example sum({<Year={2015}>}Sales) then all charts using the variable will use the changed expression.

[jpenuliar]

If 9 charts are linked objects, you can make add your expression to one and the rest will be automatically updated.

You can make use of a variable containing your expression and calling that variable in every chart definitions