If the chart is embedded in the same worksheet as the data, you can select
the chart series, then notice where the colored rectangles are which denote
the series' data. Drag the Purple (X Values) and Blue (Y Values) rectangles
around the sheet to change the data range. It's best to drag one to a
neutral (but not blank) location, because if the two rectangles are on top
of one another, it's hard to keep track.

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


"B. R.Ramachandran" wrote in
message ...
Hi,

Right-click anywhere in the plot/graph area -- "Source Data" -- click on
the "Series" Tab and manually change the column labels in the ranges
(letters
such as "A", "B"..) for "X Values" and "Y Values" (for eample, if X-Values
is
Sheet1!$A$2:$A$101, and Y-Values is Sheet1!$B$1:$a$101, changes the "A"s
to
"B"s and vice versa) -- "OK"

Regards,
B. R. Ramachandran

"Janet T" wrote:

Folks
A colleague has created a chart but needs to swap the X & Y axes. I know
this isn't as easy as it sounds, as I've been reading through lots of
entries
in this forum. I have found Jon Peltier's fantastic little .zip file
(SwitchXYAxes.xls) however, when I try and run the "Active Chart -
Switch X
Y Axes" option I get a run time error "1004 unable to gt the
MinimumScaleISAuto property of the Axis class". I'm now stuck as I know
next
to nothing about VBA.

I would be really, really grateful if someone could come back with either
an
answer to swapping axes, or to get Jon's little macro running.

Thanks a lot
Janet