1 Reply Latest reply on Sep 20, 2018 5:12 AM by albert wong

    Aligning line on Axis to Average?

    albert wong

      Edit:

      Hi,

      The formula below takes the Max Count + Min Count / 2 to come up with a centered axis which shows where the data falls from the median.

       

      What i'm trying to do is get the line to align with the average which is determined by the field [Shipped Dec 2017] ...

      Or get the center to become the 4 and roll the axis down.

       

      Any suggestions?

      Workbook attached. thanks!