reverse axes Excel XP 2002

[sev]

Hi,
I can't find the way of doing the following properly:

My data are the following X=F(depth)

so I selected the depth as X axis and data as Y.
Then I tought it would be better to switch the axes so that the dept
would be vertical, with first value on top.


I am playing with the scatter display, switch axes, reverse values an
so on... without a great success (allways something wrong, like dept
axes appears on rightside instead of left...)

does anyone knows a tutorial for this ?

Thanks a lo

 

[Frank Kabel]

Hi,

have a look at
http://peltiertech.com/Excel/Charts/axes.html#SwitchXY
http://peltiertech.com/Excel/Zips/SwitchXYAxes.zip

Frank

 

[Tushar Mehta]

In a XY Scatter chart there is no concept of first or top. Every value
is plotted at the specified (x,y) coordinate. So, it is not clear what
"with first value of top" means.

If all you want to do is switch the vertical (y) and horizontal (x)
axes, then assuming your current x values are in column A with the y
values are in column B, copy the A values into C and plot B:C. Does
that give you what you want?

--
Regards,

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

 

[sev]

thanks for the information on scatter graph.
If I use a line graph chnaging X and y won't make the trick.

let say I have value x from 0 meter to 100 meters with correspondn
values in % from 0 to 1

I would like to have on my left an axes from 0 meter to 100 meters
on the top the % values.

when copying depth values in column C I obtain a line (Point Y wit
depth value

 

[Tushar Mehta]

I'm sure that what you wrote makes sense to you, but I am at a total
loss.

A line chart is not a xy scatter chart. The x-axis in each behave very
differently.

And, I don't have the faintest idea of how to interpret the last two
paragraphs. Sorry.

--
Regards,

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