Then that's dynamic. Dynamic means that you don't have to keep going into the Source Data.. and changing where the chart *sees* it's information from, that it will update automatically. This is usually done with some sort of a)SERIES formula, b)an OFFSET function using named ranges, or c)INDEX/MATCH combo using named ranges (my personal favorite), or a combination. But it sounds like you already have it dynamic.

Just wondering if there was anything else you needed help w/ on this.