Hi, basically I have a chart with a bunch of data in it that is
dependant on the value in drop down list. So when I pick a different
selection from the dropdownlist, the data in the chart changes as
desired. The only thing that doesnt change automatically, is the chart
title, and the chart legend values. Is there a way to do this? any
ideas or thoughts would be much appreciated.

Thanks,

Joel


--
Boon8888
------------------------------------------------------------------------
Boon8888's Profile: http://www.excelforum.com/member.php...o&userid=30647
View this thread: http://www.excelforum.com/showthread...hreadid=508193