Dunno. My experience shows that it only works if the ranges referenced in the Series formula are on the same sheet. As soon as you reference ranges on another sheet, it bombs.

I also tried to create a range name to combine the two ranges, but with no success.

Maybe the OP in the linked question had a typo in the sheet name and their ranges were all on the same sheet. ?? Since the thread in your link is relatively recent, maybe you could enquire there?