Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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%
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