Hello,

I've been attempting to align a two axis chart that is created in my macro so that the horizontal axis crosses at 0 on both axes. A very popular link with this type of problem is that solution from peliertech (http://peltiertech.com/Excel/Charts/AlignXon2Ys.html).

I've attempted to adopt that code into my macro so that the axes align automatically starting with the max and min values of the ranges from which the series are plotted and cannot get it to work. Any help would be greatly appreciated and thank you in advance.

Please Login or Register  to view this content.