Displaying a liste of Xi, Yi points

  • Thread starter Thread starter Oriane
  • Start date Start date
O

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
 
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
 
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
 
Back
Top