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

Hi,

Yes you probably need to be a member of CodeCage to see the attachment.

For me deleting the secondary vertical axis causes the series on the
secondary axis to use the primary axis scaling.

To make the secondary Y axis match the primary Y axis the simplest thing
is to add another dummy series to the secondary axis. This only needs 2
values, the MIN and MAX values from the source data. Change the chart
type to line instead of column. Format the line to have no marker or
line formatting.

Cheers
Andy

On 26/02/2010 13:32, alanbr wrote:
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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Hi Andy

That worked a real treat!! Thanks so much.

Regards
Alan