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

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

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

Randall

"Andy Pope" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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