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

  • Thread starter Thread starter epu
  • Start date Start date
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?
 
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.
 
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.
 
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?
 
Back
Top