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.
Workbook attached. thanks!