I need to be able to enter an operators name and a date range to populate a graph on efficiencies of said date range. The table I'm pulling data from has the associate's names in column A, week ending dates on row 1 and corresponding efficiency data for each operator on each week ending date. On a separate tab, I need to enter the operator's name, any given date range and have a graph populated for that range. I've tried the offset function, but can't make it work. Any ideas on how to perform this task? I much appreciate any guidance!
