I don't know why it didn't work. I've only rarely had it happen, but
sometimes others have had a problem. It could be some irregularity in the
source data range, or some additional bulleproofing I would have included if
it were a commercial package.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
"Janet T" wrote in message
...
Jon
thank you very much. Any ideas why your .zip file didn't work?
Regards
Janet
"Jon Peltier" wrote:
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