Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Gradient Colored bar Graph | Charts and Charting in Excel | |||
How To Find The Gradient Of A Graph | Charts and Charting in Excel | |||
How do I get the gradient at a point on a curved graph? | Charts and Charting in Excel | |||
Gradient of line chart | Charts and Charting in Excel | |||
want to make a bubble graph with 20 bubbles and gradient coloring. | Charts and Charting in Excel |