Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
glukes
 
Posts: n/a
Default How do I graph x,y pairs of numbers with Excel?

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.
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

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/
_______


glukes wrote:

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
In Excel, I want to have all telephone numbers display in the sam. Fluffy from Wisconsin Excel Worksheet Functions 7 March 18th 05 02:05 AM
Excel countif based on size of numbers in one column in Access Kristjan_Thor Excel Worksheet Functions 3 March 17th 05 10:21 PM
How do I create a Bell Curve Graph in Excel fratton Charts and Charting in Excel 2 March 17th 05 06:39 PM
Numbers after decimal point excel to word mail merge Andy P Excel Worksheet Functions 1 March 15th 05 11:48 AM
I have a set of numbers in an excel spreadsheet and want to find t Charles Excel Discussion (Misc queries) 4 January 11th 05 11:39 PM


All times are GMT +1. The time now is 12:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"