I assume then the problem is alignment of the zero's on each axis.
In which case see Jon Peltier's page
http://peltiertech.com/Excel/Charts/AlignXon2Ys.html

Cheers
Andy

osof wrote:
Yes. I put the percentage in the 2nd axis. I tried doing it without the
negative figures and it turns out ook sometimes but when I try to put in the
negative figures it totally changed the chart instead of just adding a
stacked column at the bottom. IT semms like negative figures for stacked
columns doesnt' wanna work with the
percentage line series.

Sorry about my example... Here's more. Thanks for all the help!

Liablities Net Book 1 Book 2 Gross

0.00% 0.00%
2004 ($28,000) $28,000 $47,000 $9,000
2003 (29,000) 40,000 45,000 10,000
2006 (30,000) 42,000 50,000 11,000 330.80% 252.80%

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info