Need secondary axis scaling to be inline with primary
 

Have primary axis scaling in hours, have secondary scale showing $. They are
not very proportionate and both have negatives, but need the zero indicator
on both to be in line since the chart is a bar chart. Is this possible
without adjusting the scale by hand to make them line up?

Need secondary axis scaling to be inline with primary
 

By hand or with a macro:

http://peltiertech.com/Excel/Charts/AlignXon2Ys.html

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


"colin919" wrote in message
...
Have primary axis scaling in hours, have secondary scale showing $. They
are
not very proportionate and both have negatives, but need the zero
indicator
on both to be in line since the chart is a bar chart. Is this possible
without adjusting the scale by hand to make them line up?