Is it possible to dynamically add chart series' based on dynamic named range?

[marsh_e79]

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 Data Source dialogue, and it creates a perfect chart based on the current size of the range (also see example attached):

When I then add a row to the data set which needs to be added dynamically as a series to the chart, the dynamic range updates (because it's dynamic - yay!) but the chart doesn't add the new series because the dynamic range I pass in (per above) gets converted into a static, absolute range reference (it's no longer dynamic so it ignores the new rows - Boo!).

Can anyone help? Hoping this thread can be a gamechanger for anyone else encountering similar if we can find a solution!

NB: Unable to use VBA or Table object - has to be dynamic named-range-based.

Thanks!!

 

[StephenCrump]

You can use dynamic ranges to change the number of data points (or the data points illustrated) in the chart, but not to change the number of series.

You could do it using VBA - if you were able to use it!