Hi,

Which sub-type of line are you using? Stacked lines can not have Trendlines.

I created a line chart with 2 data series, number and percents. Placing the
percents onto the secondary axis.
When I select either series and right click I can see the Add Trendline
option.

The Trendline dialog, Type tab, allows me to pick which series to base the
trendline on.
Can you see both series in the list, Based on Series: ?

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Rita Palazzi" wrote in message
...
Microsoft Office 2000


I have two graphs on one chart and both axis are used. The left axis is
based on whole numbers. The right axis is based on percentages. I have
no problem adding a trendline to the line graph using the left axis. I
cannot add a trendline to the line graph using the right axis
(percentages). When I right click the line graph and select "Add
trendline" nothing shows up. However, the "undo" feature says "Undo add
trendline". Could Excel be trying to use the left axis as reference for
this trendline?

Also, for additional information... I've had others in my workgroup using
newer versions of Excel to try to add the trendline as well. No luck with
newer versions either.

Any help is greatly appreciated!

Rita Brasher
Project Engineer / Int'l MIS and Analysis
FedEx Express