Dynamic Chart Title - reg

[RajV]

Hi,
Is it possible to have dynamic chart title in pivot chart.
i.e.,
Scenario
=========
I have Project name as page field

Whenever I choose the project name from the drop down
list, my chart title should reflect the projectname
accordingly.

- RajV

 

[Andy Brown]

Sorry, missed the

pivot chart

bit.

I've never done one. But it seems you can ref the page field in another cell
(eg: page field in F1, "=F1" in G1), then "=G1" for the title.

Rgds,
Andy