VBA for chart automation: 2 axes

[amateur_excel]

I am using excel 2003, and have a chart with two axes; the secondary axes does not have the zero point in line with the zero point on the primary axis. I need both of the following:

1. Both axes must have zero points in line with each other
2. I need different scales on both of the axes

All of this needs to be automated through a macro.

I've been able to get a macro working to set each axis' zero point to the same level, but then I cannot find a way to automate scaling, while keeping that zero point the same.

Any help is much appreciated!

 

[Hermanito]

My way of trying to do this would be to do the complete action manually and record it with the macro recorder. Afterwards, post that code here and we can help clean it up so it does what you want...