I apologize if this has already been answered for someone else, but I'm having trouble finding the answer for myself.
What I'm trying to do is display a simple line graph based on a data validation selection. I have 24 employees for which I want to show production numbers per day but I want the ability to select one individual and have it display the number per day for the month. Here is a snapshot of the data showing the first five days in January for two employees:
Jan. 2013 1 2 3 4 5
Amarilys 4 7 10 13 16
Angerrilynn 5 8 11 14 17
Basically, if I select "Amarilys" I want a line graph showing her production numbers per day in January. I'm hoping to do this with existing Excel formulas and functions as I'd like to avoid the use of macros. Is this possible?
Thanks for your help!!!
Bookmarks