Hi Andy

First off, thanks so much for replying so quickly!
Secondly, I did what you said and it worked up to a point - the
problem being that
the secondary axis has a different scale to the primary axis.
I only realised this after I deleted the secondary axis and finished
all the steps.
This chart (or rather the source data) is going to be populated from a
database via VB and then
sucked into a Word report.

How can I (via macros if necessary) ensure that the secondary axis and
primary axis are the same scale?

Thirdly, I clicked on the Download link on your reply, thinking it
might help even more but got blocked 'cos
of permissions.

Thanks very much for your help so far.

Regards
Alan