How do I graph x,y pairs of numbers with Excel?

G

glukes

i want to simpy graph ordered pairs of number. There may be repeats of x or
y or both. Both ranges of numbers are numbers; neither is a label. This has
to be possible.
 
J

Jon Peltier

Put the X values in a column. Put the Y values in the next column, so
the pairer values are positioned next to each other. Select the range of
values you've entered, and start the chart wizard: click the button on
the standard toolbar with a small chart on it, or choose Chart from the
Insert menu. In step 1 of the chart wizard, select the Scatter chart
type (fifth item down the list on the left), then follow the rest of the
wizard.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Y-axis values correspond to x- axis value 1
Use text descriptors as Y axis units 1
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Changing y axis labels 1
x-y scatter graph and confused 0
Combining a 2-D column graph and a 2-D line graph on the same char 3
How do I specify X,Y axis and Series values in a line graph? 5
Conditional number format of x-axis based on value? 2

Top