Displaying a liste of Xi, Yi points

[Oriane]

Hi there,

I have 2 columns with X and Y coordinates. Eache line give Xi, Yi for one
point.

Can I display a two D diagram with these points ?

Best regards

 

[Pete_UK]

Are you using Excel 2007, or an earlier version?

Pete

 

[Oriane]

Hi Pete,

Are you using Excel 2007, or an earlier version?

I use Excel 2007

Regards

 

[Pete_UK]

Ah, that's a pity, as I don't have that version, so I'm not sure how
you would invoke the Chart Wizard.

In earlier versions, you would just need to highlight the Xi,Yi data
that you have in the two columns and then click on the Chart Wizard
icon. Then you can select XY (scatter) from the list, then click on
the picure that represents how you want the graph to appear (basically
just dots, or with lines joining the dots), then you can click on the
panel "Hold to view sample" to see if that is the style of graph you
were expecting. If so, then you can just follow through the wizard by
clicking Next to move to the next panel.

Hope this helps.

Pete

 

[Mike Middleton]

Oriane -

Arrange data in adjacent columns with X values on the left and corresponding
Y values on the right. Select all data. In Excel 2007, choose Insert |
(Charts) Scatter | Scatter with only markers.

- Mike Middleton
http://www.MikeMiddleton.com
Excel Add-ins and Books for Business Analytics

 

[Oriane]

Thank you !

 

[Oriane]

Hi Pete,
"Pete_UK" <[email protected]> a écrit dans le message de
[...]

Hope this helps.

Yes indeed !

Thank you

 

[Pete_UK]

You're welcome, Oriane - thanks for feeding back.

Pete