HELP ! stupid EXCEL question

[Bluga]

How do i draw XY graph in Excel?

Say i want a Q vs V graph, what should i put into the cell?

Thanks!

 

[Bluga]

help!

 

[AmitPatel]

make a column with your x values, another column with Y values, highlight it, click the graph button, pick the type of graph...usually XY Scatter for a simple x vs. y graph...then follow the wizard.

 

[Bluga]

i have (1,1) (2,2)

but it gave me 4 points!

i should get 2 points.

 

[Bluga]

please i'm dead 🙁🙁🙁🙁🙁🙁

 

[Bluga]

help!

 

[AmitPatel]

1 1
2 2

Did you do it like that, then highlight it?

 

[Bluga]

help!

 

[AmitPatel]

excel is wierd..for some reason it goes across for series when you so little data points.

 

[AmitPatel]

1 2
1 2

Do it like that

 

[Bluga]

yea but u got four points 🙁🙁🙁

 

[kranky]

I don't know what you mean by a "Q vs. V" graph. But if you do the cells like this:

A1=1
B1=1
A2=2
B2=2

and do what AmitPatel said, it looks OK to me.

 

[Bluga]

yes i got it!!

Thank you for saving my life 😉

 

[AmitPatel]

kranky, that's what I though at first too, but excel did series across with just the two data points, so this way worked for me:

A1=1
B1=2
A2=1
B2=2