+ Reply to Thread
Results 1 to 14 of 14

X axis....

  1. #1
    Registered User
    Join Date
    01-11-2007
    Location
    Aberdeen, Scotland, UK
    Posts
    21

    X axis....

    Please help,

    Hi

    I have a problem with Data on a graph.
    3 lines of data
    2 should plot on graph and the other is where the data exists, although this is being used as the x axis. I need the x axis to go from 0 - 3 and not

    X Axis - Plot 1 - Plot 2
    0 100 0
    0.125 99.75 0.25
    0.18 99.22 0.78
    0.25 97.42 2.58
    0.355 94.63 5.37
    0.5 92.46 7.54
    0.71 89.25 10.75
    1 83.8 16.2
    1.4 70 30
    2.8 32.3 67.7


    its not going up in scale like it should do. The points are appearing as the values I have typed in column A, which is right. But they don't go up in the right scale on the x axis.

    I can send anyone the spreadsheet if you can give me an email address, please email me @ 27hiltonheights@gmail.com

    thnaks,

    N
    Last edited by TypeR; 01-15-2008 at 04:52 AM.

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099
    Do you mean like this?
    Attached Files Attached Files
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  3. #3
    Registered User
    Join Date
    01-11-2007
    Location
    Aberdeen, Scotland, UK
    Posts
    21
    No,

    I've got that far, its a smoothed plot i graph i have...
    If i could find out how to upload I would post what I have already.

    Z

  4. #4
    Registered User
    Join Date
    01-11-2007
    Location
    Aberdeen, Scotland, UK
    Posts
    21
    See attached,

    I need the x-axis to be in a series 1 2 3 4 5 6 7 8 and not as per existing, although i also need the data to apear on the graph as per the data.

    Z
    Attached Files Attached Files

  5. #5
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099
    how about this?
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    01-11-2007
    Location
    Aberdeen, Scotland, UK
    Posts
    21
    Chippie,

    thanks,

    I tried that already.
    The X-axis should run 0 - 3 and the two lines should be plotted corresponding to the values below.
    0
    0.125
    0.18
    0.25
    0.355
    0.5
    0.71
    1
    1.4
    2.8

    Thanks again,

    Z

  7. #7
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099
    May be this time?
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    01-11-2007
    Location
    Aberdeen, Scotland, UK
    Posts
    21
    Thats the one Chip !!!

    Can you please tell me how you managed that !
    Or better still,

    Can you apply that ruling to graphs on sheets 2 & 3.

    thank you and Regards,

    Z

  9. #9
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099
    Hi,

    Finally got there, all you need to do is to click on the X axis on Sheet3, right click > Format Axis > Scale...you will see the values of the X axis, just apply the same numbers to the other charts for the X axis.

  10. #10
    Registered User
    Join Date
    01-11-2007
    Location
    Aberdeen, Scotland, UK
    Posts
    21
    Chip,

    Not quite as easy as that..

    Have a look at the format axis on the orignal graphs, they do not have the same options as the graph you have created????

    Z

  11. #11
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099
    Hi Z,

    Your right they don't, the only thing I can think of that can account for that is that I did it last night on my home pc using 2007, but saving the file in 97-2003 format.

    The pc I'm on now is only 2003, so I'll have to try again when I get home, but it may be Thursday until I can get back to you.

  12. #12
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099
    Just had a thought, I've used the one I created earlier and copied it together with the data table to the other sheets, then copied the data from sheet2 and sheet4 over the data tables, then updated the charts with the correct sheet series.
    Attached Files Attached Files

  13. #13
    Registered User
    Join Date
    01-11-2007
    Location
    Aberdeen, Scotland, UK
    Posts
    21

    Chip,

    You a STAR !!!

    Hopefully I can help you out sometime..

    Thank you very very much, Regards

    Z


  14. #14
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099
    Glad to help - thanks for the feedback

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1