Hello there !

my table
employee, date, cases picked, rate, performance

Im trying to find a way to export column which will return all dates based on specific employee.
Vlookup would return just one date which is not good. Im trying to create dynamic line chart so when my boss pick up a name he will see line chart with dates and performance for specific employee.

http://www.mediafire.com/?4x0cxb388n7kydk <- here is a sample worksheet, by learning many cool tips on this site I've managed to create some basic dashboard with sumif,and vlookup formulas.


any help would be greatly appreciated