Automation of Dynamic Chart Title and legend changes

[Boon8888]

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]

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.