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%
--
thank you!
Mavy


"Andy Pope" wrote:

Sorry but that data example doesn't really help as I can not figure out
what you are trying to plot.

Are the years plotted as series? In which case you need more % values.
If the stacks are for each year then you need to move the % values to
the secondary axis and change the chart type to line.

Cheers
Andy

osof wrote:
Here are sample values

0.00%
2005 ($28,000) $28,000 $47,000 $9,000
2006 (30,000) 42,000 50,000 11,000 330.80%

I put the zero before 2005 because the line series are the percentage ones
and it starts at 0.
Thanks for all the help.I appreciate it...