how can one get a gradient from a line graph
when drawing a line graph on excel how can you get the gradient on the line
graph |
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 |
All times are GMT +1. The time now is 03:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com