Capturing chart title from cell
 

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

Capturing chart title from cell
 

Hi,

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

Cheers
Andy

Randall Arnold wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

Capturing chart title from cell
 

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

Randall

"Andy Pope" wrote in message
...
Hi,

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

Cheers
Andy

Randall Arnold wrote:
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, Microsoft MVP - Excel
http://www.andypope.info