How do I create a chart showng slope?

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.
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to graph a slope? 1
How do I show slope on a chart? 6
how doi create a grid chart so i can plot a line ? 1
How to create a bubble chart with more than 2 variables 0
how do I find the slope of a graph? 2
Initially creating a chart 1
Charting Dated Data 1
how can i create a column chart with indices? 0

Top