Change Y axis to X axis

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, i have a 18KB excel file @ www.geocities.com/ricerox008/book1.xl
i want to reverse the X and Y axis, so that time is shown on the X axis and volume is shown on the y axis. i have tried for *AGES* to do this, but i cant

please help me, either by email or on here..

(MSN is also ok

thanks, Rice
 
Haven't downloaded the file; don't intend to.

Select the chart, then the menu item Chart | Source Data... | Series
tab. Exchange the contents of the Value (Y) and Category (X) fields.

Or...

Put the data you want to be the x-values in some column. In the column
to the right (in a left-to-right environment), put the y-values. Now,
XL will plot the data as desired.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
cheers for your time, except it didnt work

Perhaps i should explain what the data is

There are 6 test tubes
there are 10 different volume of gas evolved numbers (2,4,6,8,10,12,14,16,18). these are in 1 column. (a) (currently this is the x axis, i wish for it to be the y axis.
for test tube 1 there are 3 values, representing time. one each for 2,4 and 6. These are in 1 column. (b)
for test tube 2 there are 7 values representing time. one each for 2,4,6,8,10,12 and 14. these are in 1 column. (c
the pattern continues until test tube 6 (column g) (currently B-G are the y axis, i wish for it to be the x axis

regarding your first suggestion
the values in the value section are all different throughout the series, however the values in the category (x) axis are the same thoughout every series. so if i swap them around for 1 number, it doesnt work because excel insists that the category x axis value is the same for every series, and when i change 1 series value for category x axis, it changes the rest of the series. Hence a swap is not possible

regarding your second suggestion
It isnt really possible to rewrite the data as i have explained how the table is setout, see above (if that makes any sense

and as a btw, i am using ms office 2k3

cheers for your effort..

does anyone have another idea

Ric
 
Rice -

You need to give yourself three different sets of X-Y data, one for each
test tube. In each case, put the X value (time) in the left column of
the two, and put your evolved volumes in the right column.

Make an XY Scatter chart from the data for test tube 1. Select and copy
the data for test tube 2. Select the chart, use Paste Special from the
Edit menu, and make sure Excel uses the first column for category (X)
values. Repeat for test tube 3.

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