Linking chart title to a cell 2007

[Sean12]

In 2007, how do you link a chart title to a cell?

In my situation, I have a pivot chart and I want the chart title to change
when I change one of the filters. The filters are different sites. I would
like the chart title to change to the one item I select from the list. For
example, I have sites 1, 2 and 3. I select 1 of these, say site 1. How do I
get the chart title to change to "Site 1" automatically?

Thanks,

 

[Eduardo]

Hi,
Go to you chart, insert , text box, draw the box, go to formula bar enter

=your cell

then each time you update that cell it will automatically populate into the
chart

 

[stumac]

Hi sean, click on the chart title, go to the formula bar and enter an = sign,
then select the cell you want to link your chart to.

Hth

Stu