Thread: referencing cell content from charts

Originally Posted by sarandi

Hi,

In a worksheet cell I have a text that can change from time to time (eg. I overwrite it).
I have a chart that has a title. Is it possible that the title will show the text taken from the worksheet cell?
In the same way, from a text box in a chart can I refer to the content of a cell?

In any way, how can I put a content of a worksheet cell onto a specific position of a chart?

I don't exactly mean labelling data points (thanks I found it in the forum).

By, Szevasztok.

Hi Szevasztok,

If you select your title on the chart, wipe through the text, then go into the formula bar and put =, then select the cell on the worksheet with your text in. This will now be displayed in the title box and can be changed at will.

The same go for a text box, go to View > Toolbars and select Drawing

Select the text box and do the same as before.

Hope this is what you are looking for?

oldchippy

You made me happy!
That is what I was looking for. A handy tool for me.
How could you figure it out? Unbelievable.
I appreciate your help. Thanks.
Sarandi

Szevasztok, means in Hungarian: By and have a good time!

Glad to be of help sarandi, thanks for the feedback. I've learnt something as well.

Szevasztok