Skip to content
ProjectControls.com
Planning, Scheduling & Programming Discussion

Excel Line Graph Problem

In the Open Standard
Alex CostarasMember for 21 years 4 months
Created
6
2
0
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?
Save Follow Follow forum Report
Reply New topic

6 replies

Oldest first
  1. 0
    Sukumaran Subaramaniyan ·
    #1
    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!!!
    Report
  2. 0
    Alex Costaras ·
    #2
    Sorry for being dense, but what do I change it to, as the Y data is automatically calculated from the data range.
    Report
  3. 0
    Alex Costaras ·
    #3
    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?
    Report
  4. 0
    Raja Izat Raja Ibrahim ·
    #4
    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
    Report
  5. 0
    Alex Costaras ·
    #5
    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
    Report
  6. 0
    Sukumaran Subaramaniyan ·
    #6
    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.
    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?