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

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

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

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/...nkToSheet.html

This is the code for setting the corresat value.

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


Cheers
Andy

Joe Dunbar wrote:
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, Microsoft MVP - Excel
http://www.andypope.info