How do I change where category x axis crosses the 2nd y axis?

E

epu

I'm trying to get the x axis to cross the y axis at zero for both the primary
and secondary y axis. However, since both sets of data points has negative
figures the x axis crosses the secondary y axis at a negative number. What
am I doing wrong?
 
D

Del Cotter

I'm trying to get the x axis to cross the y axis at zero for both the primary
and secondary y axis. However, since both sets of data points has negative
figures the x axis crosses the secondary y axis at a negative number. What
am I doing wrong?
Click to expand...

You must make sure the two Y axes have maximum and minimum set to the
same proportion with respect to their zeroes. So if the primary Y axis
goes from -5 minimum to +10 maximum, and the secondary Y axis must have
a maximum of +4, then set its minimum to be -2. And so on.
 
A

AR

I tried to to the calculation as per your email, but I still can't get it to
align both axes at 0.. Can you please let me know where I input the code you
provide on your website?

Thanks.
 
A

AR

I got the code from previous link and pasted it into my Chart sheet, however
I think what complicates things is that I have already 2 primary data set and
I guess I need to enter the code for the 2nd as well?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't get the x-axis to cross at value 0 for both y-axes 3
How do I put words as the Y axis values? 0
Formatting 'X' Axis -- 2 fundamental differences 7
Secondary Axis not crossing at zero 4
Chart distorts secondary axis when the x-axis is logarithmic 5
How can I make a scatter plot graph with a category x-axis? 0
Custom EXCEL chart value axis BRAIN TEASER 1
X-axis to cross Y-axis at avrg Y-value 7

Top