If you don't want to open a workbook, here's a web page with an answer:

Align X Axis to Y=0 on Two Y Axes (VBA)
http://peltiertech.com/Excel/Charts/AlignXon2Ys.html

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 3/16/2010 8:38 PM, Al Charbonneau wrote:
Hi

I am using Excel 2007 to do a chart that has a company's revenue presented
in columns on the primary vertical axis and the year over year change in
revenue presented in lines on the secondary vertical axis. The problem I
have is that in 1996, the company lost money and in 2008 it had a profit. I
would like to but seem unable to get the 1996 column to show below the line
while the 2008 column begins at 0. It appears as though the problem is
influenced by the secondary vertical column which needs to begin at 0.

Would appreciate help.

Thanks

Al