Results 1 to 4 of 4
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Having the craziest time trying to get this right.

    Not having the original data, I'm estimating in Excel the following:

    6 1
    6.5 5 0
    7 10 4
    7.5 11 8
    8 12 12
    8.5 20 14
    9 22 13
    9.25 25 13.75
    9.5 23 14

    but, can't seem to get a line graph to look like the attached image. Pulling my hair out.

    Thanks in advance for any help/suggestions...
    Attached Images Attached Images

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    I think you want an XY chart not a line since your Xs are not equally spaced.

    How is this example? It is not exactly the same, but you get much of it. The gridlines could be modified if desired.

    Steve
    Attached Files Attached Files

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post
    Hi there

    The trick is the way you lay you data out and the use of the na function so as to not plot the "missing" parameter in the the first row.

    The steps to follow (using my Excel wb attached)

    1) High light A1:B16
    2) Click Chart Icon
    3) Select XY (Scatter) and choose "Scatter with data points connected"
    4) Click Next until you reach Finish
    5) Click Finish

    In Cell C2 type =na() press return

    6) High Light the chart
    7) Click Chart icon
    8) Press Next
    9) At this point click the Series tab
    10) Below Series, click Add
    11) X values, select A2:A16
    12) Y Axis, select C2:16
    13) Click Next until Finish

    This will now create both charts.

    Hope that is clear
    Jerry

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Great help! Thanks for the sample AND the notes.

    Kevin

    [quote name='Jezza' post='762958' date='02-Mar-2009 21:35']Hi there

    The trick is the way you lay you data out and the use of the na function so as to not plot the "missing" parameter in the the first row.

    The steps to follow (using my Excel wb attached)

    1) High light A1:B16
    2) Click Chart Icon
    3) Select XY (Scatter) and choose "Scatter with data points connected"
    4) Click Next until you reach Finish
    5) Click Finish

    In Cell C2 type =na() press return

    6) High Light the chart
    7) Click Chart icon
    8) Press Next
    9) At this point click the Series tab
    10) Below Series, click Add
    11) X values, select A2:A16
    12) Y Axis, select C2:16
    13) Click Next until Finish

    This will now create both charts.

    Hope that is clear[/quote]

Posting Permissions

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