Thread: Need secondary axis scaling to be inline with primary
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
  
Posts: 6,582
Default 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?


Reply With QuoteReply With Quote