View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default X axis on 0 on Line-Column on 2 Axes

Try this:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Supe" wrote in message
...
Is there a way on a Line-Column on 2 Axes chart to have the 0 value on
both
the bar and line axes be straight across from each other even though the
bar
chart is in 1,000s and the line axes is in single digits and has negative
numbers? Only way I can figure is to put negative numbers in the bar axis
as
well.