No, unfortunately you can't do this using formulas. If you change the chart area, you will see that the number of series are automatically changed. And if you input a named range, which is defined dynamically, this named range will automatically change to a "normal" range. So, if you want to achieve what you are looking for, then you need to do it using VBA.