View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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