I wanted to make sure that for any data my chart axes would be set at the minimum value for each axis. In the Excel help it says to use .Crosses = xlMinimum. So I did that, and it sets the axes to the maximum value! Can anybody shed some light on this and suggest how I can make sure that for any data, I can programme XL to set the x and y axes to the minimum values of each

Thanks.