Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
In article ,
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL Hyperlink to Charts Questions.. URGENT.. =( | Excel Discussion (Misc queries) | |||
Excel Charts | Charts and Charting in Excel | |||
My Y-axis label is cut off in Excel charts | Charts and Charting in Excel | |||
Displaying charts from excel 2003 in excel 2002? | Excel Discussion (Misc queries) | |||
Why will my Excel charts not print in color? | Charts and Charting in Excel |