Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How to increase chart area without affecting plot area? | Charts and Charting in Excel | |||
axis title text box is wrong size in chart for excel 2003 | Charts and Charting in Excel | |||
Excel 2003 charting circular or spherical coordinates | Charts and Charting in Excel | |||
BUG?: Excel scatter chart: will not plot x-values | Excel Discussion (Misc queries) |