scaling with 2 axes

J

Jason

If I have a graph on two axes, how can I make sure that
the right and left axes always line up (even if I change
the data) so the left and right axes are always even at
the first point on the left of the graph? In other
words, my left axis shows the growth of a $1000
investment over time while my right axis shows the
monthly returns that contributed to that growth. But, I
want my left axis value of $1000 (the starting point) to
always line up with 0% on my right axis. Many thanks for
the help.
 
J

Jon Peltier

Jason -

You would need to write a macro that adjusted the scales whenever the
data changed.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

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

Top