Linking Graph title to a cell

H

Hankjam

Hi

So all the help buttons say "insert an '=' into the formula line and
then hit the target cell and enter".

I must be doing something real wrong as it doesn't work for me..

that or I'm a diddie doing something way wrong.

Thanks for your time.

Aj
 
J

Jon Peltier

Select the chart title (or axis title, data label, or shape). You don't need
to click in the formula bar first, but it might make it easier to see what
you're doing, the first time or two. So click in the formula bar, type the
equals sign, then click on the target cell (the formula bar should now
contain an address like =Sheet1!$A$1) and press Enter.

- Jon
 
H

Hankjam

Select the chart title (or axis title, data label, or shape). You don't need
to click in the formula bar first, but it might make it easier to see what
you're doing, the first time or two. So click in the formula bar, type the
equals sign, then click on the target cell (the formula bar should now
contain an address like =Sheet1!$A$1) and press Enter.

- Jon
-------
Click to expand...
<snipped>

Hi Jon

Thanks for taking the time to reply. I sort of tried this and got it
to work, after a fashion. When I get the = sign my excel does not
allow me to click on the target cell...

As I say I got it to work on a couple of graphs but not using the
described procedure. The first time I had "Graph Title" and when I
clicked on the target cell, it populated the title with the text I
wanted... could not repeat that and ended up with an = sign, which I
clicked on, hightlighted and then clicked on target cell....

very strange.

Thank you

Andrew
 
J

Jon Peltier

Hankjam said:
<snipped>

Jon

As we say locally:

"The mutes nuts"!

Really good, many thanks.
Click to expand...

Andrew -

Locally to where?? I've never heard that one, and if I would say it here
(northeast US), I'd draw blank stares.

- Jon
 
Top