Graph Question. Values from different pages. Not in same cell ranges.

  • Thread starter Thread starter Marc
  • Start date Start date
M

Marc

Hi, I have an excel work book which keeps track of
players averages in a dart league.

Every week gets a different page.

I would like pages for individual players, that will keep
track of only 2 columns on a weekly basis, which I will
use to make a graph. Because the stats are sorted by
high average, the players don't always stay in the same
cells.

The long way would be for me to reference the necessary
cells, week to week. I was wondering if there is a
script that can do the following pseudocode. Using C1 in
the current individual player's sheet.

C1 = Where "Week1.Cellrange A" = "Player1", "AX" (where x
is the returned Cell)
C2 = ..Same thing, but cell range B"..

Thanks for your help. If this is in anyway unclear, I
apologize, it's been a while.
 
Hi, I have an excel work book which keeps track of
players averages in a dart league.

Every week gets a different page.

I would like pages for individual players, that will keep
track of only 2 columns on a weekly basis, which I will
use to make a graph. Because the stats are sorted by
high average, the players don't always stay in the same
cells.

The long way would be for me to reference the necessary
cells, week to week. I was wondering if there is a
script that can do the following pseudocode. Using C1 in
the current individual player's sheet.

C1 = Where "Week1.Cellrange A" = "Player1", "AX" (where x
is the returned Cell)
C2 = ..Same thing, but cell range B"..

Thanks for your help. If this is in anyway unclear, I
apologize, it's been a while.
Click to expand...

Let me take a stab at this. Your data for each week looks like this:

Name Game1 Game2 Game3 Average
Joe 100 150 125 125
Jane 90 110 130 110
Jim 100 80 90 90

Now you want to chart the player's performance as a function of time. But
the players are re-sorted based on average each week, so Joe appears on
the first line of data in the above example but he may be second in
another week.

Assuming I made the right guesses, I think you should begin with a summary
sheet. The first column will include the names of interest, the rest of
the columns will contain lookup functions. Like this:

Name Week1 Week2 Week3 Average
Joe
Jane
Jim

Assuming the data from the previously described sample sheet is in
Week1!A1:E4, the first lookup formula as entered in B2 of the sumary sheet
is =VLOOKUP(A2,'Week1'!A1:E4,5,FALSE). This pulls out the average score
for each week and puts it on the summary sheet. Modify this formula for
each column as required (i.e. change Week1 to Week2). Copy the formula
down to fill in the other rows.

Now you can chart the data directly from the summary sheet.
 
Back
Top