Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I show slope on a chart? | Charts and Charting in Excel | |||
Slope line in stacked area chart | Charts and Charting in Excel | |||
create line chart with two axises in Pivot Chart | Charts and Charting in Excel | |||
Chart data file lost - need to re-create from chart? | Charts and Charting in Excel | |||
How can I visually display slope in an excel chart? | New Users to Excel |