View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Scatter Chart - plot x&y coordinates - Excel 2003

Select the X and Y data, not the list of names, and create an XY chart.

To apply the names to the data points as labels, use one of these free and
well made utilities:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

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


"suejay" wrote in message
...
In the example below, I want 10 Widgets (x) on the horizontal axis, and 5
widgets (y) on the vertical axis of the SAME series.
Sample data:
X Y
Widgets 10 5
Gadgets 12 10
Hammers 9 7

The only way I can find to do this is in step 2 of the Chart Wizard to add
the series individually, which is very cumbersome! Help, please!