Hi,

I am trying to figure out if it possible to chart only the top row of filtered data. The situation is this:

I have a list of employees in column A. Each progressive column contains the number of absenses per period time (month in this case). Each month the table is updated to include the new numbers for each employee for that month.

The problem is that there are over 800 employees, which means that the series limitation of 255 is exceeded for charting. I have column A filtered so I can select one employee's name and view only their numbers across the sheet. But what I am required to do is present a line chart that updates based on the employee name selected.

Normally, with less than 255 rows, one could just plug all those employees in as series and have the chart ignore non-visible rows to show only the filtered employee, however that doesn't work in this case given the sheer number of employees.

Is there anyway to define the top row data and chart it whether it is row 4, 60, 122, etc?

Thanks,

Neo