4 Replies Latest reply on Sep 17, 2013 9:36 PM by Louis Keating

    Find Axis Maximum in One Worksheet, Apply to Another.

    Louis Keating

      Hey guys!

       

      Sorry in advance for the confusing question...

       

      I've got two charts which need to have the same axis maximum.  Since axis maximums aren't dynamic, I'm using a calculated field and a reference line.

       

      How can I use this calculated field and apply it to the reference line on two sheets?

       

      The formula for my Max x Axis is:

       

      (SUM([Likes])/COUNT([Likes]))*1.15

       

      Which is doing the same calculation as my chart, then increasing by 15%.

       

      When I use the same on my second chart, the Sum and Counts are different, so how can I pass the result of one calculated field into the second?

       

      Thanks,

      Lucas