switch x/y axes

[Biff]

Hi

How can i switch x/y axes in a user-defined graph ?
The data series are in 3 columns.

Biff

 

[Jon Peltier]

Biff -

If it's an XY Scatter chart, this little macro works wonders:

http://peltiertech.com/Excel/Zips/SwitchXYAxes.zip

Next time, arrange the data with the X values in columns or rows before
the Y values, then make the chart.

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

 

[Guest]

Hi

Thanks for yours hints. But as already mentioned, it is a
user-defined graph (combination bars and lines), and not a
XY scatter chart.

Biff

 

[Jon Peltier]

I very cleverly avoided fixing that mess. I'm afraid you're going to
have to do some combination of rearranging the data and rearranging the
setup of the user defined chart, then you'll have to recreate the chart.
But that means next time it will be ready to go.

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