Sometimes (on the Y-Axis) Excel will give you an extra tick mark above and
beyond the tick above the highest data point. (An empty band.) I would
rather it not do this. Nor do I want to completely calculate and build the
scale myself. There is one instance where it would be nice if I could
automatically correct this. The data data never goes above 1. Can I query
the graph somehow and see what maximum tick value it plans to use, and if
greater than 1 change the max value to 1?

If I could also query the tick major unit, I could then see when it has the
empty band and set a maximum value to not include it.

Or is there some simple solution and a property I could set to not allow an
empty band?

Thnaks, Don <donwiss at panix.com.