XY Chart - Vertical Axis Crosses - Cell reference vs. Value

[Joe Dunbar]

I would like to have the Axis Value refer to the result of a formula. My XY
chart is a 4 quadrant view of data points. I want the vertical axis to cross
at the median value for the range. I can enter the number by hand but I
can't use the cell reference.

Thanks,
Joe

 

[Andy Pope]

Hi,

You will have to solve this with some VBA code.
This example is for Scales min/max value but the principle is the same.
http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html

This is the code for setting the corresat value.

With ActiveChart.Axes(xlCategory)
.Crosses = xlCustom
.CrossesAt = 2.5
End With


Cheers
Andy