PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Link text box to a cell

Reply

Link text box to a cell
 
Thread Tools Rate Thread
Old 03-07-2003, 05:11 PM   #1
Tracy
Guest
 
Posts: n/a
Default Link text box to a cell


I have cell data that I would like to display in various
locations on my chart. Can I link the cell data to a text
box (or something similar)? Thanks!
  Reply With Quote
Old 03-07-2003, 06:11 PM   #2
Tracy
Guest
 
Posts: n/a
Default Re: Link text box to a cell
Thank you...this is wonderful! How do I select the text
box afterwards to modify it?

>-----Original Message-----
>To link a cell's contents to a textbox:
>
>1. Select the chart
>2. Click in the formula bar, and type an equal sign
>3. Click on the cell that contains the formula
>4. Press the Enter key.
>5. Position the textbox where you'd like it in the chart,
and format as
>desired.
>
>Tracy wrote:
>> I have cell data that I would like to display in
various
>> locations on my chart. Can I link the cell data to a
text
>> box (or something similar)? Thanks!
>
>--
>Debra Dalgleish
>Excel FAQ, Tips & Book List
>http://www.contextures.com/tiptech.html
>
>.
>
  Reply With Quote
Old 03-07-2003, 06:42 PM   #3
Tracy
Guest
 
Posts: n/a
Default Re: Link text box to a cell
Never mind...it's working now...mouse pointer has to be in
exactly the right spot. Thanks again Debra.
>-----Original Message-----
>Thank you...this is wonderful! How do I select the text
>box afterwards to modify it?
>
>>-----Original Message-----
>>To link a cell's contents to a textbox:
>>
>>1. Select the chart
>>2. Click in the formula bar, and type an equal sign
>>3. Click on the cell that contains the formula
>>4. Press the Enter key.
>>5. Position the textbox where you'd like it in the
chart,
>and format as
>>desired.
>>
>>Tracy wrote:
>>> I have cell data that I would like to display in
>various
>>> locations on my chart. Can I link the cell data to a
>text
>>> box (or something similar)? Thanks!
>>
>>--
>>Debra Dalgleish
>>Excel FAQ, Tips & Book List
>>http://www.contextures.com/tiptech.html
>>
>>.
>>
>.
>
  Reply With Quote
Old 03-07-2003, 08:14 PM   #4
Debra Dalgleish
Guest
 
Posts: n/a
Default Re: Link text box to a cell
You're welcome. I'm glad you've got it working, and thanks for posting
back to let me know.

Tracy wrote:
> Never mind...it's working now...mouse pointer has to be in
> exactly the right spot. Thanks again Debra.
>
>>-----Original Message-----
>>Thank you...this is wonderful! How do I select the text
>>box afterwards to modify it?
>>
>>
>>>-----Original Message-----
>>>To link a cell's contents to a textbox:
>>>
>>>1. Select the chart
>>>2. Click in the formula bar, and type an equal sign
>>>3. Click on the cell that contains the formula
>>>4. Press the Enter key.
>>>5. Position the textbox where you'd like it in the
>>
> chart,
>
>>and format as
>>
>>>desired.
>>>
>>>Tracy wrote:
>>>
>>>>I have cell data that I would like to display in
>>>
>>various
>>
>>>>locations on my chart. Can I link the cell data to a
>>>
>>text
>>
>>>>box (or something similar)? Thanks!
>>>
>>>--
>>>Debra Dalgleish
>>>Excel FAQ, Tips & Book List
>>>http://www.contextures.com/tiptech.html
>>>
>>>.
>>>
>>
>>.
>>
>


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

Archive


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off