geepeetee wrote:
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

----------------------------

Right click on the chart you made and select "Chart Type". My guess is
that you've told it to create a line chart, so since you've given it two
data series it plots two lines. You need to select the "XY (Scatter)"
chart. Then make the first data series the X data and the second the Y
data.

That should give you what you're expecting. Good luck...

Bill