You can calculate the SLOPE using the original worksheet data:
=SLOPE(Yrange,Xrange)
Or you can add a trendline to the chart. Right click on the series and
select Add Trendline.
Unless the X values are dates, you should not add a trendline to a line
chart. Use an XY chart instead.
- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______
"gradient" wrote in message
...
when drawing a line graph on excel how can you get the gradient on the
line
graph