Regarding this part of your tip:

So after you have created the chart you need to use
Chart Tools Design Data Select Data.
In this dialog Edit the series and swap the x and y values.

What version of Excel does this work for? I am using Excel XP and trying to
do the same thing as the original poster, but dont see any of these options.

Thanks.

"Andy Pope" wrote:

Hi,

Unfortunately Excel tries to help by ordering the selected range.
So with data in A2:B6, and X values in column B if you try this selection,

$B$2:$B$6,$A$2:$A$6

Excel converts it to $A$2:$B$6 and then takes the first column as the x
values.

So after you have created the chart you need to use
Chart Tools Design Data Select Data.
In this dialog Edit the series and swap the x and y values.

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Samy" wrote in message
...
Hi, using Excel 2007 i am creating a line chart using price and quantity
data. When creating chart excel default values to x and y axis (X - price
and
y - Quantity), However i require these axiss to be inverted.

How do i manually select which values got on which axis?