Filtering and a chart

[Rufus 2006]

Everyone:

This board is awesome. I have a workbook with 93000 columns in it and rows A-G populated. I am trying to create something where I can choose a name and the info I need will automatically display in a chart. I have looked into a pivot table and such but I don't think that is what I need. I am just learning (and willing to learn more) VBA, but I haven't learned enough about it to even try to create what I want in that by myself. Here is what the chart looks like.

Name Event Date Days Btw Events Weight Total +/-
Jay World 1/1/14 52.08 200
Jay Local 2/1/14 30 52.03 205 5
Pete Local 1/10/14 69.72 275
Pete Nat 3/10/14 60 68.58 270 -5

Somehow, I need to be able to select Jay and have his numbers come up in a chart. I also need for the horizontal axis labels for each meet to show the Date, Days Btw Events, and the Event.

Hopefully this is clear. I am using Excel for Mac 2011.

Thanks in advance for all the help

Rufus

 

[cyrilbrd]

Keep me posted, if you have difficulties putting it in practice just let me know and i'll give you a more thorough explanation with actual samples.

example of what a formula is for a name range called "Btw Events" =OFFSET('Rufus_2006'!$D$1,1,0,COUNTA('Garrix'!$D:$D)-1)
then in the chart you make reference to the name range Btw Events rather than to a cell range...