Thread: chart problem
View Single Post
  #4   Report Post  
geepeetee
 
Posts: n/a
Default

Hi

Thanks, that worked a treat. Just one last thing, we need a "line of best
fit" which a straight line which goes through as many points a possible.

I have drawn this on and its fine but wondered if there is a way of letting
the software do it.

Cheers
Gary
"geepeetee" wrote in message
...
Hi

We are tryng to create a simple chart for my daughters homework. It is to
show the resistance in relation to the length of a piece of wire, a line
graph is needed showing the plotted (slightly curved) line and a line of
best fit.

The data is:

resistance length of wire
0 0
0.10 10
0.23 20
0.35 30
0.50 40
0.60 50
0.70 60
0.80 70
1.00 80


When plotted it shows 2 lines (although they dont look identical to the
school example), but stranger still it has changed the values.

Can anyone advise me how to do this, i am sure its simple stuff.

cheers

Gary