View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default How do I create a chart showng slope?

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Virginia" wrote in message
...
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.