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!