Hi,
Use the text label provided by the Trendline equation. Once applied you can
then link it to a cell.
select the label and then in the formula bar type = and then click the
required cell. This will
create the required cell reference.
Cheers
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Need Help on axis problem in a chart"
ft.com wrote in message
...
I have a simple plot with two points only, and added a trendline which fits
with the plotted line. I really need to show the slope of the trend line
on
the plot. But I dont want to show the equation or anything else.
I am using a plot which should calculated and plot by itself with the
change
of inputs in the table(somewhere in the page), and need to show that slope
value on the plot too.
I can calculate slope in a cell somewhere on the sheet. Is there any way
to
show the value (calculated somwhere on the sheet) on the plot beside my
plotted line.
Either way would work. But I prefer to do it from the trendline.
please help.