Dynamic Titles in Pivot Charts

Folks,

Spent a bunch of time searching the site trying to find references on
how to make a Chart Title in a PIVOT CHART dynamic. As it is now,
"County" is a field value in my chart, which plots prehunt deer
population estimates from 1981-present. When I change county (via the
drop down list), I would like for the Chart Title to change, which
reads "Adams County Prehunt Population Trends, 1981-present." I have
found all manner of references on how to make a title dynamic (by
pointing it to a cell that will contain the value you want to be in the
title) but this is 1 step beyond that. Would anyone be willing to help
me with this?

Thanks so much in advance for all of your help - on not only this, but
other posts as well!

Regards,

Mike

Hi Mike...did you ever find an answer to your question?