Hi Friends!
Coming to you in exasperated desperation! I'm quite familiar with dynamic named ranges. I've created one for a chart data set which adjusts when a new row of data is added (see in example workbook: rngChartData). I can even pass this into the 'Chart Data Range' field of the Select...