I've tried that as well but to no avail. it changed everything to lines..the
value of my line series are percentage. no matter what I do it won't work.. I
have to manually add a trendline to form a line.. Help! someone said it's
possible but they can't remember how they did it...

--
thank you!
Mavy


"Andy Pope" wrote:

I just created a stacked column chart with 4 series of data, including
negative values. Selected one of the series and right clicked form the
context menu I picked Chart Type. Selected line chart.

What have you tried?

Cheers
Andy

osof wrote:
It's not the 3D type. It's just a stacked column with negative figures as
well and 3 horizontal lines.