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]
Tue, 2005-08-02 05:10
Alex Costaras
User offline. Last seen 8 years 8 weeks ago. Offline
Joined: 30 May 2005
Posts: 13
Groups: Petro-Chem / Oil & Gas
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?
Top

Replies

Thu, 2005-08-11 02:35
#1
Sukumaran Subaram...
User offline. Last seen 9 years 3 days 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.
Top
Wed, 2005-08-10 12:04
#2
Alex Costaras
User offline. Last seen 8 years 8 weeks ago. Offline
Joined: 30 May 2005
Posts: 13
Groups: Petro-Chem / Oil & Gas
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
Top
Wed, 2005-08-10 11:14
#3
Raja Izat Raja Ib...
User offline. Last seen 13 years 8 weeks ago. Offline
Joined: 2 Jun 2005
Posts: 299
Groups: GPC Malaysia, Petro-Chem / Oil & Gas
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
Top
Wed, 2005-08-10 09:48
#4
Alex Costaras
User offline. Last seen 8 years 8 weeks ago. Offline
Joined: 30 May 2005
Posts: 13
Groups: Petro-Chem / Oil & Gas
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?
Top
Thu, 2005-08-04 07:35
#5
Alex Costaras
User offline. Last seen 8 years 8 weeks ago. Offline
Joined: 30 May 2005
Posts: 13
Groups: Petro-Chem / Oil & Gas
Sorry for being dense, but what do I change it to, as the Y data is automatically calculated from the data range.
Top
Tue, 2005-08-02 21:57
#6
Sukumaran Subaram...
User offline. Last seen 9 years 3 days 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!!!
Top