Adding Dynamic Text Data to a Graph

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sean.mymail@googlemail.com - 03 Oct 2006 16:18 GMT

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

Reply to this Message

Bernard Liengme - 03 Oct 2006 16:31 GMT

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

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> Hi,
>
[quoted text clipped - 9 lines]
> Appreciate any ideas
> Thanks

Reply to this Message

sean.mymail@googlemail.com - 03 Oct 2006 16:51 GMT

> Click to select the chart
> In the Formula Box type = and then click the cell to be lined; this
[quoted text clipped - 19 lines]
> > Appreciate any ideas
> > Thanks

Thanks - thats exactly what I was looking for!

Reply to this Message

Gord Dibben - 03 Oct 2006 16:38 GMT

With workbook open and chart or chart sheet selected...........

Right-click on any toolbar and activate the Drawing toolbar.

Select the text box icon and draw a box on your chart.

In the formula bar enter = sign then point to the cell with the data and hit
ENTER key.

Done.

Gord Dibben MS Excel MVP

>Hi,
>
[quoted text clipped - 9 lines]
>Appreciate any ideas
>Thanks

Reply to this Message