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"
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
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.
