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!
|