+ Reply to Thread
Results 1 to 3 of 3

Adding formula to a text box in a chart

  1. #1
    Registered User
    Join Date
    08-19-2011
    Location
    New York, New York
    MS-Off Ver
    Excel 2011
    Posts
    20

    Adding formula to a text box in a chart

    Hello!

    I'm trying to add a text box to a chart that will update when I change a cell (that will link to the text box).

    Example: Cell A26 holds a drop down validation. If I choose "apples" in the drop down in cell A26, I then want a text box in a chart to say "apples".

    Another way of putting it, I would like to make a Chart Title that automatically updates when this drop-down validation in Cell A26 is changed.

    Any suggestions? (Also, I specified Excel 2011 because it seems like older Excel versions were able to just "Insert Text Box" and type in a formula, like "=A26" but that doesn't seem to work with Excel 2011. So far, I've gone to Insert Text Box, then I cut and pasted the text box onto my chart so that it moves with the chart, but I can't get a formula to work in that text box.)

    Thanks!

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,421

    Re: Excel 2011: Adding formula to a text box in a chart

    There are two kinds of text boxes. What kind are you using? If you are using a "shape" then you might want to try a "control" instead.

    This is based on Excel 2007 but I think it should also work in 2011. From the Developer tab on the ribbon, select Controls, Design Mode, Insert, then in the bottom half (ActiveX) select Text Box and create your text box. Then right click on the text box to see properties. Select LinkedCell and enter the cell that you want to link it to.

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,592

    Re: Adding formula to a text box in a chart

    You need to include the sheet name when making the cell reference.

    =Sheet1!A1

    http://www.andypope.info/tips/tip001.htm
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1