Second Y axis (same as first)

[Gaijintendo]

Is there a way to do this that does not involve VB?

I have searched through the site and seen people post about
http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html

I have tried adding another series of the same data, and hiding the data -
but this always makes the spacing on the x axis a bit 'shifted to the left'.

Any help would be very much appreciated.

 

[Andy Pope]

Hi,

You can not adjust the scales min/min values to a specific value without
using code.
If you just want the secondary axis to match the primary then you can do
that by including the maximum data value in a series on both the primary
and secondary axis. The shifting is probably caused by your choice of
chart type for the extra series. Try using a line type.

Cheers
Andy