Hi,

I need to create charts (containing 3 different types of charts x 9) and I
have all range references as Names ready. How can I write the vba in the
most effective way? Surely, I shouldn't need to write down all 27 in a sub,
it will be huge and easy to get lost into.

There is also time factor to consider - will it be faster to have templates
to copy paste and then change the links?

Also I know there are some limities with using Named ranges and Charts, but
are unsure it will affect vba coding.

Any suggestions?

/Kind regards