Add / Edit Chart Title while using Macros

**Blaze2012** · 04-10-2012, 06:30 AM

Hi everyone,

I am desperate for help and really hoping someone will be able to shed some light on this for me.
I'm new to Excel so be gentle please.

I have to create a Macro for a basic year to date sales chart.

For some reason it wont let me change the "chart title" while recording.
Everything else works great.

Am I doing something wrong ?
Can you suggest anything I can try to get it to work ?

Thanks.

**Richard Buttrey** · 04-10-2012, 06:43 AM

Hi,

I don't seem to find that limitation. However the code you may want is

Please Login or Register  to view this content.

Alternatively you can link the chart title to a cell. Select the chart title box and in the formula bar enter =A1 (or whatever cell holds the title). This will avoid the need for macro code unless of course you want to use a macro to change the A1 variable cell.

**Blaze2012** · 04-10-2012, 07:05 AM

Thank you so much for the response Richard, much appreciated.

So there is a way to do it without having to play with the code ?
I must be trying to do it the wrong way or something.

I've just noticed something else on there that I'm going to try.
Hopefully that will be the correct way to do it and I can breathe a sigh of relief.

Thanks again.

**Jon_Peltier** · 04-16-2012, 08:44 AM

Richard didn't tell you how to link a chart text element to a cell. Here's the trick, which works for chart titles, axis titles, data labels, and text boxes.

Select the text element so it is highlighted but not in edit mode. Click in the formula bar, type =, then click on the cell and press Enter. You will get a formula like:

=Sheet1!$A$1

You can only have a link to a single cell, not formulas that do computations.