Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Extracting a graph from a table (2k7)

    I have a table (attached) that has 100 rows of data and 50 columns. I want to make a graph that has the 1-100 on the Y axis and the 50-2500 on the X axis but skipping 2 rows for each column to show a data point. so my line in the graph would show this trend:

    2, 50 = 397.2127
    4,100 = 410.9158
    6,150 = 424.0888
    8,200 = 438.5363

    and so on. does what i'm asking for make sense? i don't think i can present the data in a more clear way unless someone else has a better suggestion. these data points would (i think) show the trend of the table in a fairly clear manner. i had to cut the table down in half to fit it in the attachment. also, i saved it in excel 97-2003 format.

    if i'm speaking jibberish, please tell me and i'll try to clarify!
    Attached Files Attached Files
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Extracting a graph from a table (2k7)

    Do you want a 3D chart? Or a 2D bubble chart?

  3. #3
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Extracting a graph from a table (2k7)

    can you show me the 2 styles you are talking about?

    edit: i should clarify - i don't know which either style will look like...
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Extracting a graph from a table (2k7)

    On second thought, I don't think you want either of the two. The request to put 50-2500 on the X axis and 1-100 on the Y axis is a red herring, I think, since you want them to be coordinated.

    See the attached version with a simple line chart.
    Attached Files Attached Files

  5. #5
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Extracting a graph from a table (2k7)

    thanks, hans. i don't think the line chart is actually showing me what i want to see so i'll play around with the 3d chart idea.
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Extracting a graph from a table (2k7)

    I'm afraid I don't quite understand what you're after...

Posting Permissions

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