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

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