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