His example extends the length of a series, Items on the category axis, depending on the number of data points.

You however have 2 data points, on the category axis, for each series. And you want to change then number of series, Items in the legend.

Named ranges will not do that.