Macro for chart title

  • Thread starter Thread starter T-Man
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Chart title and text formula? 1
Dynamic Chart Title With 3D Stacked Column Chart 2
Dynamically change data in chart title 2
Using a 'Name' to Update Chart Titles & "Y" Axis Scale 2
Dynamic Chart Title? 6
x-axis scale changes 3
How to hide a chart title, but keep the title in the chart 1
Maintain formatting in linked chart title 1

Back
Top