Is there a way to use VBA (or anything) to dynamically update the 'Chart Workspace Title' of a query in Chart view?



If you view the properties of the report in chart view, select Title, it's on the second tab (Format) under Caption.

I'm trying to use one query for multiple graphs, everything works great except I can't figure out how to change the title based on the information being displayed.

Thanks.