Change the number of rows for multiple data series in a chart quickly

[davidx]

Hi,

I have about 20 charts, all with 20 data series. They reference different columns of data so I can just change the source data range in one go.
Does anyone know of a quick way of automatically changing the number of rows all 20 date series reference in a single go, without having to go into every single data series doing it one at a time. Maybe a macro?
Thanks,

[berlan]

Can be done with VBA or e.g. by using named ranges that are made dynamic. Depends a bit on your worksheet structure.

[davidx]

Hi Berlan thanks. I try to avoid named ranges at all costs because I think they tend to lease to problems and reduce the purity/transparency. Are you aware of any VBA code or where I could potentially find it? Thanks,