Match 0 points on Primary and secondary axis...

[simjambra]

Hello there,

Is is possible to ensure the zeros line up on both axes?

Please see attached file for an idea of what I mean.

Thanks for your time..

Simon

[mdbct]

Right click on each y axis and choose Format Axis. In the Axis Options, change the the Max and Min from Auto to Fixed and set each to be the same. For your example sheet. Max = 25, Min = -10.

[simjambra]

Ah thanks.

If the values don;t match, will you only ever get a line (at the zero point) on the primary axis?

[mdbct]

If you are referring to the horizontal line connecting the two y axises , then yes, the line will only be for the primary axis' zero value.

If you have your chart selected, you can run the following macro to automate the process I described in my first post.

Please Login or Register  to view this content.

[simjambra]

Ok that's a great help, thanks.