Hi,

Maybe something like this VBA code.

Sub DynamicChartTitle()
Dim rngTitleText As Range

Set rngTitleText = ActiveSheet.Range("D7")
With ActiveChart
.HasTitle = True
.ChartTitle.Text = "='" & rngTitleText.Parent.Name & "'!" & _
rngTitleText.Address(ReferenceStyle:=xlR1C1)
End With
End Sub

Cheers
Andy

Henry Boyd wrote:
I am creating a spreadsheet tool that will be distributed as a template.
The output will be a chart that will graphically show the performance of a
particular quote. I would like the title of the chart to be driven by the
contents of one of spreadsheet cells. Is that possible?

TIA

Henry Boyd

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info