I am trying to create a chart that has a data range that will automatically adjust based on the number of results I want to display. The source data is in a pivot table, but I have to pull it out of the pivot into a standard table because I do not want all of the fields in the pivot included in the chart (the pivot sorts the data based on a variance, but I do not want the variance in the chart). Here is the issue, the standard table that I'm building the chart off is hundreds of lines, but I want the chart to update based of a driver based number of records to return (e.g. 1st 10 records, 1st 20 records, etc..basically if 10 records doesn't explain what I need, I'll pull in 20, or 30...). I've seen the suggestion of using offsets in named ranges to have the chart update as the number of records changes, but my number of records does not change, but the number displayed in the chart off a fixed data set is what I'm trying to change. Any ideas?