Dlookup on pivot chart field

[deb]

Is it possible to use a DLookup to name a field in a pivot chart?

If user changes the data in the "Criteria" field, I want the name of the
pivot chart to reflect the change.

If so, please let me know how.
Are there any other suggestions?

Thanks