I am using a chart with both a primary and secondary axis. The primary
axis runs from -4% to 8% while the secondary runs from -1000 to 1200.
The 0 point on the secondary axis equates to about 1.5% on the primary
axis which makes the graph is a little confusing. Is there any way to
add dummy numbers or series or otherwise get the 0 point on the
secondary axis at about the same spot vertically as on the primary
axis?

Thanks in advance for any ideas.

--Dan

Please ignore my post. I'm embarrassed at how simple the solution was:
simply make the ratio of max to min of the two axes the same.

On Nov 27, 5:16 pm, "Dan" wrote:
I am using a chart with both a primary and secondary axis. The primary
axis runs from -4% to 8% while the secondary runs from -1000 to 1200.
The 0 point on the secondary axis equates to about 1.5% on the primary
axis which makes the graph is a little confusing. Is there any way to
add dummy numbers or series or otherwise get the 0 point on the
secondary axis at about the same spot vertically as on the primary
axis?

Thanks in advance for any ideas.

--Dan

For the secondary axis, Format Axis/ Scale, and set the maximum value to
2000 instead of 1200.
--
David Biddulph

"Dan" wrote in message
oups.com...
I am using a chart with both a primary and secondary axis. The primary
axis runs from -4% to 8% while the secondary runs from -1000 to 1200.
The 0 point on the secondary axis equates to about 1.5% on the primary
axis which makes the graph is a little confusing. Is there any way to
add dummy numbers or series or otherwise get the 0 point on the
secondary axis at about the same spot vertically as on the primary
axis?

Thanks in advance for any ideas.

--Dan