Depth Chart (transposed scatter chart)

[Quentin]

I have a very common requirement to make depth plots
(various parameters against the depth of a drill hole)
A scatter chart does just what I want EXCEPT that it's
the wrong way round. i.e. depth is the X axis and it
should be the Y axis. I can manually cut and paste the
data series reference to swap them but it's annoying to
have to do this every time.

Is there a simple check box or other easy way to
transpose the X & Y axes?

Thanks

 

[Bernard Liengme]

Hi Quentin,
Here is a site with a macro to do it for you
http://www.geocities.com/jonpeltier/Excel/Charts/axes.html#SwitchXY
Bernard

 

[Jon Peltier]

Also, I've put some code that will automatically generate YX charts if
the data is arranged differently:

http://www.geocities.com/jonpeltier/Excel/ChartsHowTo/QuickChartVBA.html#xycharts

- Jon

 

[Quentin]

Hey Thanks - that works. however Excel should really be
ablt to do this - are you listening Microsoft?

 

[Tushar Mehta]

Why should the default capability include a YX chart? Then, how would
one create a XY chart?

Doesn't really require a whole lot of effort to duplicate the 1st
column after the 2nd column and plot the 2nd and 3rd columns as a
chart!

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jon Peltier]

Tushar -

The issue might be when one wants to make a chart with several series
like this. So you put X to the left and Y to the right, great, that's
one series, but then you have to add each additional series one at a
time. The default for generating a multi-series chart is XYYY, but
Quentin might have data like XXXY.

I've made myself a toy addin that will plot data of various arrangements
like this, all series at once. It would be convenient to have the
capability built in, but then the chart wizard would become an unwieldy
mess.

- Jon

 

[-VJ-]

Hi Jon,

as geocities does not exist any longer, I was wondering if you could post the macro you made for excel scatterplots again? I am currently experiencing the problem of having to "swap" the x and y data of a traditional scatterplot which is not trivial when working with around 80 series of x data... I think what you did in the past could make the job fairly easy

Many thanks in advance for your support!

Vassilena