Computing.Net > Forums > Office Software > LineChart finding slope in excel

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

LineChart finding slope in excel

Reply to Message Icon

Name: Mariam
Date: January 29, 2009 at 18:32:21 Pacific
OS: Windows XP
Subcategory: Microsoft Office
Comment:

Okay, so I've been given a few values to plug in and make a line graph.
I put my values, my y-value & x-values in the cells, one for each value. I obtained the chart, but now I want find out the slope. How would I do that?



Sponsored Link
Ads by Google

Response Number 1
Name: jon_k
Date: February 3, 2009 at 06:10:39 Pacific
Reply:

easiest way, involving no calculations:

enter your data in two columns (x-result, y-result).

Highlight the data in question. Insert an x-y scatter graph. Right click on the series and add trendline. Use linear, and in the options tick the box that shows "display formula on line".


0

Response Number 2
Name: Milchoo
Date: February 3, 2009 at 15:05:22 Pacific
Reply:

What about if Ive been given three different datas. (like 3 questions to do and each of them have their own x and y values) And I want to have them all on one graph. And make it seem its a straight line rather than in XY SCATTER if I do it it gives me point to point. I want a linear function.(just a straight line showing). I fuond out to do the slope. But I can only do it for one of the data, I have two more, and they cant seem to fit in the same graph..How will I be able to that?


0

Response Number 3
Name: jon_k
Date: February 4, 2009 at 01:02:22 Pacific
Reply:

your trendline will give you a "line of best fit". Make sure you're using a trendline and NOT just the scatter graph with smoothed lines joining point to point.

So you'll just have a series of unconnected points. Right click on one of them and "Add trendline". It will default to linear, then find the option to display equation on line. Should be sorted.

If this doesn't work, use maths instead.

Gradient = change in y divided by change in x. So if your values are

X  Y
3  0
7  3

Your gradient is 3 divided by 4, or 0.75


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: LineChart finding slope in excel

Is Text-to-Speech in Excel 2007 www.computing.net/answers/office/is-texttospeech-in-excel-2007/7407.html

Using FIND function-VBA in Excel www.computing.net/answers/office/using-find-functionvba-in-excel/8283.html

Scroll in Excel www.computing.net/answers/office/scroll-in-excel/6055.html