Thread: how to best show data on graph?

Hello

Im trying to show data for individuals from a drop down list, and its based on a few criterias

Im trying to make my index, match formula lookup
a) look the year (i.e. 2010, 2011); person's name, revenue report to use.

the part im struggling with is, how can i reference the person's name to be a match source?

here is my formula:

=INDEX(Table9,MATCH($D$7,INDEX(Table9,0,1),0)+1,MATCH($C12,INDEX(Table9,1,0),0))

it works perfectly, but im not sure how i can make it reference the employee name

D7 = year selection from drop down (2010, 2011)
C12 = period i want data to show for (which week i want show i,e. P1W1, P1W2 etc)

that portions works fine and provides me with correct info., however I have the person's name in cell D6, not sure how i can incorporate that into the formula?

also, my graph appears to not be working, the scroll graph :s

Im grateful for the help! Cheers

Hello,

if you want to get a good overview and tutorials for dynamic charts, take a look at http://peltiertech.com/Excel/Charts/Dynamics.html

If you get stuck on a specific issue, please pipe up.

cheers,

Hello,

you need to adjust the row in the Index/Match by the row offset for that person. For example in D11 and copied down

=INDEX(Table9,MATCH($D$7,INDEX(Table9,0,1),0)+1+MATCH($D$6,INDEX(Table9,0,2),0)-2,MATCH($C11,INDEX(Table9,1,0),0))

cheers,