Bill Martin -- (Remove NOSPAM from address)
Guest
Re: chart problem
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
Bookmarks