Do you mean two trendlines, which are best fit lines fitted to a bunch of
points? Or do you mean you want two line chart series?
I presume it's the latter, because nobody should ever compute a trendline
from a column chart.
Make the chart as a line chart using all three series worth of data. Right
click the one line you want to change to a column, choose Chart Type, then
select a column chart type for that series. Much nicer than using the lame
built in types, because now you control the chart.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Atwork today" wrote in message
...
I'm trying to get one bar line with two trends lines. I've tried using
custom
type charts by selecting "Line-Column on 2 Axis". With selecting this
chart,
it will have 2 bar lines and one trend line instead of what I need. I've
formatted both axis to fit the correct numbers. I just need two trend
lines.
Any help would be great.