Depth Chart (transposed scatter chart)

  • Thread starter Thread starter Quentin
  • Start date Start date
Q

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
 
Hey Thanks - that works. however Excel should really be
ablt to do this - are you listening Microsoft?
 
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
 
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
 
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
 
Back
Top