Copy chart and change data range

Hi dflak,

Indeed so!

Depending on how the data are laid out, it can also be accomplished using named dynamic ranges

In fact it probably SHOULD be implemented using dynamic ranges if the various data tables contain significantly different amounts of data


Thanks for your comments, and keep up the good work!

Best regards,

Greg M

Hello,

my problem is, that all the data table are in the same worksheet (see attached sample). Therefore I can't copy the chart and change the name of sheet in the reference.

My chart start is in column N. Is there a simple way to generate the same chart for all the other tables in the sheet?