Automation of Dynamic Chart Title and legend changes

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

You can link the chart title to a cell that's also dependent on the
value selected in the dropdown list --

Select the chart title
Type an equal sign, then click on the cell that contains the calculated
title
Press the Enter key.

You could also use formulas in the label cells, so they change when a
selection is made from the dropdown list.

Boon8888 wrote:
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




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html