Results 1 to 6 of 6

Thread: XY Scatter Plot

  1. #1
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Brighton, Michigan
    Posts
    184
    Thanks
    10
    Thanked 0 Times in 0 Posts
    Good Day To All,
    I have multiple columns of numerical data in columns a, b, c,. The y values or column c range from 135 to 155, each of the two coulmns of "x" values
    range from .09 to .35 for column a and for column b from .07 to .34. The scatter graph utilizing columns c with column b works fine, the one using
    column c with a does not. The y and x axis scales in the good or correct plot range from 125-155 and 0.00 to 0.40 repsectively. In the bad plot the same
    scales are 0-160 and 0-140 respectively. I have tried modifying the scales with no success. I noticed that when using the wizard for the bad plot, the
    Source Data Data Range is blank, but the data series is filled in and correct. Any suggestions? When dealing with an Excel table with many columns of data, it is real difficult to designate which dat you wish to utilize for ...in this case an XY Scatter Plot.

    Many Thanks,
    Marty
    Regards,
    Marty

    "Aerodynamics Is For Those Who Cannot Build Engines" - Enzo Ferrari

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Can you upload a sample sheet displaying the correct and incorrect results?

  3. #3
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Brighton, Michigan
    Posts
    184
    Thanks
    10
    Thanked 0 Times in 0 Posts
    [quote name='mbarron' post='791755' date='02-Sep-2009 02:12']Can you upload a sample sheet displaying the correct and incorrect results?[/quote]

    Hi,

    attached is a copy of the excel file, shhet one is the source or original data, sheet 2 contains what I copied from sheet 1 to make it easier. Does excel allow charting of two non-adjacent colums of data? I think it may have something to do with whether or not there is text or a label in the top cell of each column.

    thank you for your assistance.

    regards,
    Marty
    Attached Files Attached Files
    Regards,
    Marty

    "Aerodynamics Is For Those Who Cannot Build Engines" - Enzo Ferrari

  4. #4
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Does excel allow charting of two non-adjacent colums of data? - Yes


    How I did it (on sheet 1)

    Highlighted the column for the X axis values - data only
    Launch the chart wizard
    choose the XY scatter
    Next>
    choose the Series tab
    copy the range showing in the Y values
    paste the range into the X values
    change the Ss in the Y values to the column letter for your first Y value series (K or L in your sample book)
    click into the Name box
    highlight the cell you want to use as the name for the series
    click the add button to add another series
    paste the data you copied earlier into the X values and in the Y values boxes
    change the Ss in the Y values to the column letter for your second Y value series (K or L in your sample book)
    highlight the cell you want to use as the name for the series
    finish the wizard as you normally would

    See attached for the results.
    Attached Files Attached Files

  5. #5
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Brighton, Michigan
    Posts
    184
    Thanks
    10
    Thanked 0 Times in 0 Posts
    [quote name='mbarron' post='791907' date='03-Sep-2009 02:16']Does excel allow charting of two non-adjacent colums of data? - Yes


    How I did it (on sheet 1)

    Highlighted the column for the X axis values - data only
    Launch the chart wizard
    choose the XY scatter
    Next>
    choose the Series tab
    copy the range showing in the Y values
    paste the range into the X values
    change the Ss in the Y values to the column letter for your first Y value series (K or L in your sample book)
    click into the Name box
    highlight the cell you want to use as the name for the series
    click the add button to add another series
    paste the data you copied earlier into the X values and in the Y values boxes
    change the Ss in the Y values to the column letter for your second Y value series (K or L in your sample book)
    highlight the cell you want to use as the name for the series
    finish the wizard as you normally would

    See attached for the results.[/quote]
    Regards,
    Marty

    "Aerodynamics Is For Those Who Cannot Build Engines" - Enzo Ferrari

  6. #6
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Brighton, Michigan
    Posts
    184
    Thanks
    10
    Thanked 0 Times in 0 Posts

    Cool

    Thanks again....lesson learned highlight only the numeric column data, add the title info later....this was a big epiphinay for me.
    Regards,
    Marty

    "Aerodynamics Is For Those Who Cannot Build Engines" - Enzo Ferrari

Posting Permissions

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