ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how can one get a gradient from a line graph (https://www.excelbanter.com/excel-discussion-misc-queries/229173-how-can-one-get-gradient-line-graph.html)

gradient

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

Jon Peltier

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