Capturing chart title from cell

[Randall Arnold]

I have a chart embedded in my worksheet. The data is a series of production
defect types drawn via ODBC from a SQL server. The nature of the production
errors may change from run to run and I would like this reflected in the
chart title. Specifically, I'd like the chart title to grab its content
from a certain cell. Other than VBA, is there a way to do this?

Thanks,

Randall Arnold

 

[Andy Pope]

Hi,

Instructions here
http://www.andypope.info/tips/tip001.htm

Cheers
Andy

 

[Randall Arnold]

Thanks Andy! If that works, I can get rid of that VBA security dialog. : )

Randall