Primary and Secondary Y Axes Not Autoselecting Same MAX/MIN Values

[VLG]

Hello,

Sometimes, I like to plot *ONE* set of line chart data along both the primary and secondary vertical axes. This is done as a visual aid (so the reader may follow a data to either the left or right, depending on which side of the chart the data is closest to). However, the problem is excel sometimes does not automatically set the same MAX/MIN values for both the primary and secondary vertical axes, resulting in appearance of *TWO* separate line charts at different 'heights' along the Y axis. Is this a bug? Am I missing something as, ideally, I want the same MAX/MIN values for both the primary and secondary vertical axes to be autoselected. Note I am aware of manually overriding these settings, but my these particular charts are templates used for wide ranges of data, so manually overriding is not preferred.

VLG

 

[Gerald Higgins]

I don't understand how you can have one set of line chart data, i.e. one chart data series, and at the same time two separate line charts.

Are you saying you actually have two chart data series, with one plotted on the primary Y axis and one on the secondary ?

 

[VLG]

@ Gerald Higgins

Yes, apologies for the misnomer. I plot the same set of data two times, once along the Primary and once along the Secondary. For some reason, the MAX value on the secondary vertical axis is not the same as the MAX value on the primary vertical axis.

EDIT: Excel 2010 on Windows 7.

 

[Andrew Poulsom]

I can't reproduce that behaviour in a quick test. Can you post some sample data?