Scaling charts using a VBA variable

[akronpow]

I'm trying to manipulate the scale of the X axis on a series of charts. The charts compare two data points each. The auto-scaling generally works fine, until the two data points are small and very close in value. For example, 3.5 is shown as enormous compared to 3.4, when for purposes of my chart the difference is negligible.

So I want to run a procedure that says 'for each chart, if the high data point is less than 10, the scale range of the X axis should be 0-10.' I can write this code, but am having difficulty accessing the high data point value. What property should I be looking for?

[mrice]

.MaximumScale