Best way to create 27 charts with vba?

[Gunnar Johansson]

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

 

[Jan Karel Pieterse]

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

 

[Gunnar Johansson]

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

 

[Tom Ogilvy]

you might get a better response posting in

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