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

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

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

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

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

Hi,

Any chance your chart is a Line chart and not a xy scatter chart.
Line charts have a categorical x axis so that property would not be
applicable.

Cheers
Andy

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


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Hi Andy - No, its definitely an XY Scatter. Thanks Janet

"Andy Pope" wrote:

Hi,

Any chance your chart is a Line chart and not a xy scatter chart.
Line charts have a categorical x axis so that property would not be
applicable.

Cheers
Andy

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


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info