Aligning horizontal 0 axis, chart with two axis

I have a chart with two axis. One showing value and one showing percent. When the curve or column goes of the chart I update the scale but then the category axis is not aligned (0 value and 0% is not on the same horisontal axis any longer). I then need to recalculate and manually adjust the scale to have 0 on same horisontal axis.

Is there any way of having this done automatically, it's currently not an optimal situation since it's time consuming to correct all the charts (the original file has many charts).

Attached is an example with data sheets and chart sheet.

Regards,
Niklas

Financial Analyst

Using:
Excel 2003, Win XP

Hi Andy,

Thanks for you reply. Do you know where I can download an example of this. I've tried but I keep getting error code. I would like to see a working example to figure out what I'm doing wrong.

Rgds
Niklas

I get this error when trying to create a chart just like the one in the example Andy gave me above..

Compile error:
Ambiguous name deteced: AlignY_PrimaryMinimium

I'm really struggeling with this, would it be possible for you to add the code to the file I attached and upload it? It would really help me see what I'm doing wrong.

Thanks

I have attached the file, I pasted the code into the VBA editor, maybe it should be somewhere else?

Sorry, I feel really stupid, my knowledge in VBA coding is almost zero, but I will soon take a course.

Any help is appreciated.

Thanks Andy

An additional question....Is the idea to run these macros each time or is it possible to have the alignment done automaically?


Regards,
Niklas