View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default How do I show slope on a chart?

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.