ExcelBanter - Apologies For No Subject. Chart Title via a Macro

Sorry for the double post

"Alan" wrote in message news:...
Hi,

ActiveChart.SetSourceData Source:=Sheet5.Range([R35])

I have a macro which will give graphic display of data from several
sources
via the contents of Sheet5.Range([R35])
in the above snippet of code. The contents of this cell are changed by a
VLOOKUP table with the lookup value coming from a combo box .

My question is, can I do a similar thing with the TITLE of the chart. That
is to say, change the title to reflect the values shown from the same data
source by putting the title in a cell, say Sheet5.Range("A1") then using
Sheet5.Range([A1]) in the macro.

I have tried all (the little) I know and searched Google to no avail. Any
advice will be gratefully received.

Reading this, I'm not sure if I've made clear what I'm trying to do, I
hope
I have

TIA

Alan.