Yes, the XY chart is what I wanted, all along. OK, almost the
1.) How do I add a secondary Y axis (data)? If I select columns A,B & C,
the chart is created with both lines and both axis correctly, but "add
secondary Y axis" is greyed out.
2.) How do I rename "Series 1" and "Series 2" labels?
"Jon Peltier" wrote:
If you put the X values to the left of the Y values, select them both, and
create the chart, Excel should automatically use the leftmost column for X
values.
Quick trick: so Excel doesn't make two sets of lines, make an XY chart
(which you probably want anyway, because the line chart treats X values as
nonnumeric labels). You can select an option that uses markers and lines. If
you still think you want a line chart per Microsoft's definition, you can
right click on the chart and pick Chart Type to change it.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______
"baltobernie" wrote in message
...
In Excel 2002, Column "A" data: 6, 7 8, 9, 10. Column "B" data: 200, 300,
400, 500
When I try to create a line chart, Column "B" data is in the X axis. I
want
Column "A" data on the X axis, so I swap the two columns. No matter, the
chart still puts 200, 300, etc. on the X axis!
How do I choose which column is X, and which is Y?