Thread: Dynamically titling Excel charts

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

In article <Xns96AF736AA4A59lhboydlhbcocom@130.81.64.196>,
purchasing@lhbco.com says...
> 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
>
See Dynamic Chart Title
http://www.tushar-
mehta.com/excel/newsgroups/dynamic_chart_title/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

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