Scatter Chart - plot x&y coordinates - Excel 2003
 

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!

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!