How do I create a chart showng slope?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Virginia - 21 May 2008 22:04 GMT

I am taking a science course and have to create a chart showing the slope and
then insert it into a word.doc.

No trouble creating the chart, but when i enter the =SLOPE(A2:A6,B2:B6)
I get the message: "reference not vald"

Would appreciate some hep with this.

Reply to this Message

Bernard Liengme - 21 May 2008 23:24 GMT

For your equation to work, A2:A6 must contain the y-values and B2:B6 the
x-values.
The text at the top of your numbers must NOT be included
I bet you have them the other way - since the other way is what we want for
charts
So use =SLOPE(B...., A.....)

But this does not explain the error you report - did you tell us everything?

If that does not work (and homework is not due tomorrow) send me the file --
to my private email
best wishes

Signature

Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

>I am taking a science course and have to create a chart showing the slope
>and
[quoted text clipped - 4 lines]
>
> Would appreciate some hep with this.

Reply to this Message