Linking Graph title to a cell
 

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

Linking Graph title to a cell
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Hankjam" ........ wrote in message
...
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

Linking Graph title to a cell
 

On Mon, 2 Jun 2008 17:52:52 -0400, "Jon Peltier"
wrote:

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

Linking Graph title to a cell
 

Don't enter the = sign as the text of the label. Select the label without a
cursor within it, and enter the = sign in the formula bar, which is located
just above the column letters above the sheet.

I wrote up an illustrated tutorial in my blog:

http://peltiertech.com/WordPress/200...ext-to-a-cell/

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


"Hankjam" ........ wrote in message
...
On Mon, 2 Jun 2008 17:52:52 -0400, "Jon Peltier"
wrote:

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

Linking Graph title to a cell
 

On Wed, 4 Jun 2008 15:30:47 -0400, "Jon Peltier"
wrote:

Don't enter the = sign as the text of the label. Select the label without a
cursor within it, and enter the = sign in the formula bar, which is located
just above the column letters above the sheet.

I wrote up an illustrated tutorial in my blog:

http://peltiertech.com/WordPress/200...ext-to-a-cell/

- Jon

<snipped

Jon

As we say locally:

"The mutes nuts"!

Really good, many thanks.

Andrew

Linking Graph title to a cell
 

"Hankjam" ........ wrote in message
...
On Wed, 4 Jun 2008 15:30:47 -0400, "Jon Peltier"
wrote:

Don't enter the = sign as the text of the label. Select the label without
a
cursor within it, and enter the = sign in the formula bar, which is
located
just above the column letters above the sheet.

I wrote up an illustrated tutorial in my blog:

http://peltiertech.com/WordPress/200...ext-to-a-cell/

- Jon

<snipped

Jon

As we say locally:

"The mutes nuts"!

Really good, many thanks.

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

Linking Graph title to a cell
 

On Fri, 6 Jun 2008 08:30:08 -0400, "Jon Peltier"
wrote:


"Hankjam" ........ wrote in message
.. .
On Wed, 4 Jun 2008 15:30:47 -0400, "Jon Peltier"
wrote:

<snipped
As we say locally:

"The mutes nuts"!

Really good, many thanks.

Andrew -

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

Hi Jon

Locally is the UK: though the expression is more English than Scots,
what I am!

It comes from another expression "The Dog's ********", which is used
as a term of appreciation for something that is good.

http://www.phrases.org.uk/meanings/dog's%20********.html

Yers

Andrew

Linking Graph title to a cell
 

I get it, "the cat's meow".

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


"Hankjam" ........ wrote in message
...
On Fri, 6 Jun 2008 08:30:08 -0400, "Jon Peltier"
wrote:


"Hankjam" ........ wrote in message
. ..
On Wed, 4 Jun 2008 15:30:47 -0400, "Jon Peltier"
wrote:

<snipped
As we say locally:

"The mutes nuts"!

Really good, many thanks.

Andrew -

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

Hi Jon

Locally is the UK: though the expression is more English than Scots,
what I am!

It comes from another expression "The Dog's ********", which is used
as a term of appreciation for something that is good.

http://www.phrases.org.uk/meanings/dog's%20********.html

Yers

Andrew