Have a look here for details.
http://www.andypope.info/tips/tip001.htm
I have tried it and it does work.
Cheers
Andy
Need Help on axis problem in a chart wrote:
No, It didnt work,
I tried typing = then a cell destination.
it just showed me what I typed. It did not take the vales from the cell.
or IF I select the equation level and go to formula bar, the equation level
just disappears.
Is there any other way to get it to work ??
Thanks in advance
"Andy Pope" wrote:
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"
soft.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.
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info