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

In article <B5CC2C73-3C23-4951-BFA2-(E-Mail Removed)>,
(E-Mail Removed) says...
> Hi, i have a 18KB excel file @ www.geocities.com/ricerox008/book1.xls
> 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
>

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

Rice wrote:

> 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?
>
> Rice
>
>

absolutly perfect, thanks alot!, it worked perfectly

Rice