1 Reply Latest reply: Mar 9, 2015 10:12 AM by Piet Hein van der Stigchel RSS

    How to link vertical axes across two charts

      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%

        • Re: How to link vertical axes across two charts
          Piet Hein van der 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