I am doing an excel sheet for work but I am completely stumped on a problem.
I have a sheet with about 950 rows and a few columns showing features and about 10 columns showing a trend in data. I need to filter the data by the features and have the filtered data automatically show in a line graph. The problem is excel will only allow 255 series per graph (so it won't allow me to select all of the data before I filter it.) Right now I have the first 255 rows set in a graph. The problem is when the data is filtered the data stays in its original assigned cell so it will only graph the data that was originially in the first 255 rows. So basically if after the filter there were 2 series and one was originally in row 100 and one was in row 300, only the the one in row 100 shows on the graph. I need the graph to show all of the filtered data.

This is exactly what I want, except I have 950 rows.
http://chandoo.org/wp/2009/02/12/mak...-data-filters/