align x & y axis

  • Thread starter Thread starter finastar
  • Start date Start date
F

finastar

Hi everybody

i am charting two data series on a single chart. I am using two y axes
and one x axis. How can I make the x axis cross both Y axes at zero???
My problem now is the x axis crosses the left y axis at 0 but other
values at the right y axis ....

thanks a lot!!!
 
Adjust the min./max. values of the secondary (or primary) y axis so
that both 0 values line up with the x-axis. Typically, this requires
ensuring that the ratio of the Y-Max/Y-Min values for both y-axis are
the same.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top