Automatic minimum at x/y intersection

[NoCanDo]

Hi all

I'm using Excel 2003.

I'm struggling to enable an automatic minimum at x/y intersection of a series of charts. The standard interface only allows this to be set manually.

Can this be done dynamically?

I have encountered some vba script which seems like it will do the trick, but I don't know how or where to use it:

Please Login or Register  to view this content.

Can someone help me out by 'walking me through the process'?

Kind regards

NoCanDo

[Andy Pope]

Can you post example of the chart.

If you always want the intersection to be at the minimum value then I think you can get away with setting the Crosses at value to be a large negative value. If the axes are automatic the actually value used for crossing will be the lowest value on the axis.