Just thinking about what you have said further.

Are you sure you want a line graph?

I think you want a column chart.

This would give you:-

1. The letter A appearing on the X axis and above that it would show blocks
(filled columns) representing 23 and 87.

2. The letter B on the X axis and above that it would show blocks (filled
columns) representing 200 and 500.

Try a column chart (Clustered Column) and I think that you will arrive at
the solution you seek.

Please hit Yes if my comments have helped.

Thanks.



"gvm" wrote:

I have data that I want to put in a simple line graph: The data is
A B
23 200
87 500

I mark the 6 cells, select insert chart / line and get a chart with both A
and B labels on the x axis. I go to "select data source" and try "switch
row/column" and get A and B as series names in the legend. How do I get the
label A and the values 23 and 87 on the x axis, and label B and values 200
and 500 on the y axis please?
(Congratulations Microsoft for making something that was so easy and
powerful in Excel 2003 an absolutely primitive disgrace in Excel 2007!) TIA
... Greg