I have a chart that at the moment has a vertical range from -70 to
-92. I'm trying to set the horizontal axis to cross at the minimum
value, in this case -92. Using

With ActiveChart.Axes(xlValue)

.Crosses = xlMinimum

It crosses at -70.

If I use xlMaximum I get the same thing.

Using
.Crosses = xlCustom
.CrossesAt = -92

it crosses at -92. however, I need it to be dynamic so the x-axis
labels stay below the data field.

Am I using xlMinimum in a place it cannot be used?

Any help will be appreciated.