when drawing a line graph on excel how can you get the gradient on the line graph
G gradient Apr 28, 2009 #1 when drawing a line graph on excel how can you get the gradient on the line graph
J Jon Peltier Apr 29, 2009 #2 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-06-ACNJ/AdvExcelConf200906ACNJ.html _______
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-06-ACNJ/AdvExcelConf200906ACNJ.html _______
