Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Excel Line Graph Problem

6 replies [Last post]
Alex Costaras
User offline. Last seen 5 years 28 weeks ago. Offline
Joined: 30 May 2005
Posts: 13
I’ve want to swap round the X and Y axes on an Excel Line Graph produced by the Graph Wizard. I.e. I wish to plot the X data on the Vertical Y axes and the Y data on the horizontal X axes. Any ideas how I do this, witout altering the origical data from which the graph is drawn?

Replies

Sukumaran Subaram...
User offline. Last seen 6 years 20 weeks ago. Offline
Joined: 2 Mar 2005
Posts: 229
Groups: GPC Malaysia
Alex,

At present there are not many choices and flexibility in Excel. You got to bear with Scatter XY graph with values on both X and Y axes.

Else, if you got AutoCAD using value and category try to draw the graph manually. Maybe it will help you.

Good Luck.
Alex Costaras
User offline. Last seen 5 years 28 weeks ago. Offline
Joined: 30 May 2005
Posts: 13
Hi, sorry but these still have the X axis as the category axis and the Y axis as the value axis. I need to turn them round so that the categories appear on the verical axis rather than the horizontal. Thanks anyway
Raja Izat Raja Ib...
User offline. Last seen 10 years 28 weeks ago. Offline
Joined: 2 Jun 2005
Posts: 299
hi there,
maybe u can see the sample as per attached..
Free Image Hosting at www.ImageShack.us
is it like the one u said...i just try to guest your needs
Alex Costaras
User offline. Last seen 5 years 28 weeks ago. Offline
Joined: 30 May 2005
Posts: 13
What I’m trying to do is make the Y axis a Catagory axis and the X axis the value axis (By default they are the other way round)for line graphs (not scatter graphs, which have bot X and Y as values axes). Anyone have any suggestions?
Alex Costaras
User offline. Last seen 5 years 28 weeks ago. Offline
Joined: 30 May 2005
Posts: 13
Sorry for being dense, but what do I change it to, as the Y data is automatically calculated from the data range.
Sukumaran Subaram...
User offline. Last seen 6 years 20 weeks ago. Offline
Joined: 2 Mar 2005
Posts: 229
Groups: GPC Malaysia
Go to: Source Data > Series tab > change the range of cells at Values and Category (X) Axis Labels.

This will swap the X data to Y axes and Y data to X axes.

Cheers!!!