switch x/y axes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Biff - 30 Apr 2004 10:02 GMT

Hi

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

Biff

Reply to this Message

Jon Peltier - 30 Apr 2004 13:28 GMT

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/
_______

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

Reply to this Message

- 30 Apr 2004 13:56 GMT

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

>-----Original Message-----
>Biff -
[quoted text clipped - 22 lines]
>
>.

Reply to this Message

Jon Peltier - 30 Apr 2004 16:23 GMT

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/
_______

> Hi
>
[quoted text clipped - 35 lines]
>>
>>.

Reply to this Message