macro for chart data range extension
 

Hi,

I've 12 graphs with 6 lines each.

I want to extent the ranges of the lines and labels with 1 column
(already extists in data range).

Is there a way to run a macro that replaces the column label in all
the data ranges from $AH to $AI. Maybe for all the charts in the
worksheet at once?

Cheers,

Harold