1.) Right-click on the data series you want to move to the 2nd y axis.
Select "Format Data Series...". Select the "Axis" tab. Choose "Secondary
Axis".

2.) If the data you selected had header text (labels) at the top of each
row, then those labels would show up on the chart. If not, right-click on
the chart, select "Source Data...". Click on the "Series" tab. For each
series, type in a name in the "Name:" box.

--
-------------------
If toast always lands butter-side down, and cats always land on their feet,
what happen if you strap toast on the back of a cat and drop it?
Steven Wright (1955 - )


"baltobernie" wrote:

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?