Hello All,

I'm trying to create line charts to chart the work my employees do during the week, the month, and the year. I have my employee names in column A running from A2 through A25. I have the dates running across the top in row 1, running from A1 through BW1. As I add dates I would want the chart to include those dates as they are put in the data fields. I'd like to create two drop down menus in N35 and W35 so I can compare emplyees that do similar jobs. I've messed around creating ranges for the X axis and ranges, but can't seem to get them to work right. Is there any help or direction that someone can give me?

Thanks,