Hi,

Here are a couple of explanations.

http://tushar-mehta.com/excel/newsgr..._tutorial.html
http://www.andypope.info/tips/tip001.htm

Cheers
Andy

Dave Breitenbach wrote:
I've learned about dynamic charts in this forum which has been very helpful
in autmating some charts that I use. I would also like the chart title be
linked in some way to a cell. Is that possible?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info