I have two dynamic lined charts whose chart areas are aligned; however,
because the y-axis values change dramatically when graphing different
ranges, the chart plot areas misalign (Y-axis shift to the right to
accomodate larger y-values displayed next to vertical axis). This
annoying behavior essentially puts the the two charted lines in the two
charts out of alignment. Locking the chart areas by code does not help,
since the plot area is the culprit!
Any help on how to align the actual plot areas by VBA code? (to be
clear, the aligned areas must not include the y-axis values which can
alternate between 1-100 range to 1-1000,000 range)
Thank you in advanice for your valuable assistance.

Alseikhan


--
Alseikhan
------------------------------------------------------------------------
Alseikhan's Profile: http://www.excelforum.com/member.php...o&userid=32364
View this thread: http://www.excelforum.com/showthread...hreadid=524606