How do I create a chart showng slope?

  • Thread starter Thread starter Virginia
  • Start date Start date
V

Virginia

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.
 
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
 
Back
Top