# Thread: Extracting a graph from a table (2k7)

1. ## 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!

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

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

3. ## 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...

4. ## 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.

5. ## 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.

6. ## 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
•