I have a sheets with charts whose series, for example, go from A3 A11
(X) to B3 B11 (Y), another chart ranging from A6A11(x) C6C11 (Y) and so
on..


Everytime I add a row of data I manually have to add the new point to
each chart.

Is is possible to select a chart and run a macro that would, for
instance, substitute a number I choose in the data range for another
one? That way I would be able to change the boundaries of each chart
faster.

Many thanks,