Macro for chart title
 

I need a macro to link a chart title to a cell or range

Macro for chart title
 

Hi,

Macro recorder is good for things like this, assuming not xl2007.
You can only link to 1 cell. If you have multiple cells you will need to
concatenate them in a single cell and link to that.

' linked to A1
ActiveChart.ChartTitle.Text ="=Sheet1!R1C1"

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"T-Man" wrote in message
...
I need a macro to link a chart title to a cell or range

Macro for chart title
 

Do you need a macro, or are you unfamiliar with the manual way?

Select the axis title, chart title, data label, or shape, type = in the
formula bar, then click on the cell.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"T-Man" wrote in message
...
I need a macro to link a chart title to a cell or range