Adding Dynamic Text Data to a Graph
 

Hi,

I would like to add extra information to an Excel graph. For example
some summary information linked to cells - so when the cells update the
summary information on the graph will update as well.

I thought about adding text fields for example, but cannot find a way
to link the contents of the text field to a cell value.

How can I do this?

Appreciate any ideas
Thanks

Adding Dynamic Text Data to a Graph
 

Click to select the chart
In the Formula Box type = and then click the cell to be lined; this
generates a formula with the form =Sheet1!$A$1
Move it to the desired location on the chart.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
ps.com...
Hi,

I would like to add extra information to an Excel graph. For example
some summary information linked to cells - so when the cells update the
summary information on the graph will update as well.

I thought about adding text fields for example, but cannot find a way
to link the contents of the text field to a cell value.

How can I do this?

Appreciate any ideas
Thanks

Adding Dynamic Text Data to a Graph
 

Bernard Liengme wrote:
Click to select the chart
In the Formula Box type = and then click the cell to be lined; this
generates a formula with the form =Sheet1!$A$1
Move it to the desired location on the chart.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
ps.com...
Hi,

I would like to add extra information to an Excel graph. For example
some summary information linked to cells - so when the cells update the
summary information on the graph will update as well.

I thought about adding text fields for example, but cannot find a way
to link the contents of the text field to a cell value.

How can I do this?

Appreciate any ideas
Thanks



Thanks - thats exactly what I was looking for!