Named ranges in dynamicl plots

Hi everyone,

I have a dynamic scatter plot with named ranges in the X and Y series like this:

Please Login or Register  to view this content.

(these named ranges use offset and count formulas...)

but everytime i make a copy of this sheet the plot in the copied sheet assume the range in the previous sheet and not the function names so that the dynamic feature no longer works, the series formula in the plot appears like this:

Please Login or Register  to view this content.

although in the name manager appears a new function name referring to the copied sheet...

how can i solve this issue?

I would appreciate any suggestions you may have

Hi Andy,

Thanks for your answer!

I guess it's another fine feature from MS.

Can i ask you for some guidance in how to implement this changes in series formula by code? i'm thinking in changing it by pressing a command button, but i think i can manage the button part.

Thanks again

Hi,

Thanks for the answer that seems to work.

cheers