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:

ActiveChart.Axes(xlValue, xlPrimary).CrossesAt = ActiveChart.Axes(xlValue, xlPrimary).MinimumScale

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

Kind regards

NoCanDo