Hi Gunnar,

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.


Do you really need to see all 27 charts at the same time? You might be better
off creating three dynamic charts which you can change using e.g. some
dropdown controls.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com