+ Reply to Thread
Results 1 to 3 of 3

Linking chart label to a cell

  1. #1
    Forum Contributor
    Join Date
    07-16-2008
    Location
    USA
    Posts
    142

    Linking chart label to a cell

    Is it possible to link a chart label to a cell? (which isn't part of the chart data) If that isn't possible, how about inserting a shape/balloon popup, can that include a link to a cell?

  2. #2
    Registered User
    Join Date
    11-22-2010
    Location
    Finland
    MS-Off Ver
    Excel 2003, 2007
    Posts
    95

    Re: Linking chart label to a cell

    Yes - put just something into chart title (which is what you meant by label, right?) to make the field visible. The field should be selected after you hit 'ok' but do select it if it's not. Type then an equal sign and click the cell you want the title to be referred.
    An example file is never useless!

    Tried an example function of mine and got errors?
    - Had you found them, replace ; with , and , with .

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

    Re: Linking chart label to a cell

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

    for data labels there is a free addin
    http://www.appspro.com/Utilities/ChartLabeler.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