Hello, this can definitely be done with dynamic range names. Deleting columns will get you into trouble, because the series reference will be updated.

Post a workbook with your data structure and chart. A small data sample with dummy data should suffice.

cheers,