Display Cell Data in titles/Text Boxes on Charts
 

Hi -

I would like to link my chart title textbox or another text box to a cell in
a worksheet - can anyone suggest a way of acheiving this?

Many thanks
Neil

Click on the chart to select it
Type an equal sign -- you'll see it appear in the formula bar
(you don't need to click in the formula bar before typing)
Click on the cell that contains the text for the chart, e.g. C6
Press the Enter key.
Drag the text box from the centre of the chart to the top
Use the buttons on the formatting toolbar to format the text


Neil Perry wrote:
Hi -

I would like to link my chart title textbox or another text box to a cell in
a worksheet - can anyone suggest a way of acheiving this?

Many thanks
Neil


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks Debra - Very useful.

"Debra Dalgleish" wrote:

Click on the chart to select it
Type an equal sign -- you'll see it appear in the formula bar
(you don't need to click in the formula bar before typing)
Click on the cell that contains the text for the chart, e.g. C6
Press the Enter key.
Drag the text box from the centre of the chart to the top
Use the buttons on the formatting toolbar to format the text


Neil Perry wrote:
Hi -

I would like to link my chart title textbox or another text box to a cell in
a worksheet - can anyone suggest a way of acheiving this?

Many thanks
Neil


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html