View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default how can one get a gradient from a line graph

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