That's Excel 2007. It's easier in 2002:

Chart menu Source Data Series tab.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"am_81" wrote in message
...
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 axis's to be inverted.

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