How to link vertical axes across two charts

[#1]

Hi I have multiple (4) charts that show sales figures (y axis) per period (x axis).

How can I link the y axis scales (max value actually) amonst those 4 charts? So let's say it's always the maximum value in any of the the charts +10%

[stigchel]

I would copy the expressions from the 4 charts to 4 variables, e.g. named Max1, Max2............

Where Max1 would be

=Max(Aggr(YourExpression1,YourTimeDimension))

Max2:

=Max(Aggr(YourExpression2,YourTimeDimension))

..........

Then Add a variable e.g. MaxAll:

=Max(ValueList(Max1,Max2,Max3,Max4) + 0.1

You can then use this MaxAll variable in the Static Max expression of the Scale (Axes tab) for each of the charts