Use a macro to expand data series for chart?
 

How can I write a macro to expand each of the data series for a chart to
include one additional column?

I want it to work without knowing how many data series there are or what the
current range is. Basically, I want it to expand my ranges by one additional
column to the right.