you might get a better response posting in

news://msnews.microsoft.com/microsof...excel.charting

--
Regards,
Tom Ogilvy

"Gunnar Johansson" wrote in message
...
Hi,

It should be integrated into a report, where static text already exist.
More
likely, I think of hiding some parts of the report sometimes, since there
will be a lot of work to convert the current layout etc.

Thanks for the idéa, anyhow. Any else with some old code template for me
to
borrow..


/Regards


"Jan Karel Pieterse" skrev i meddelandet
...
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