+ Reply to Thread
Results 1 to 3 of 3

Data Label References Move when Rows Are Hidden

  1. #1
    Registered User
    Join Date
    03-15-2017
    Location
    Long Beach, CA
    MS-Off Ver
    365 Pro Plus
    Posts
    14

    Data Label References Move when Rows Are Hidden

    I have a chart which contains data labels where I have gone in an manually changed the labels to reference specific cells. The references to the cells are locked using "$" before the column and row indicators so I expect them not to change. However, whenever I hide a row (or set of rows) the cell reference changes (even if I'm not hiding the row that is being referenced). Anyone else have this issue?

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

    Re: Data Label References Move when Rows Are Hidden

    Have a look at this for explanation and possible solution
    http://andypope.info/ngs/ng57.htm
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    03-15-2017
    Location
    Long Beach, CA
    MS-Off Ver
    365 Pro Plus
    Posts
    14

    Re: Data Label References Move when Rows Are Hidden

    Quote Originally Posted by Andy Pope View Post
    Have a look at this for explanation and possible solution
    http://andypope.info/ngs/ng57.htm
    This doesn't address the issue. It has to be specific to this workbook. When I copy everything into a new workbook, the behavior stops. My cell reference in the new workbook is locked and does not change when hiding/unhiding data. The only problem is that I need the chart to be in my existing workbook, not a new one. I'm wandering if there is any workbook-specific option that is engaged that makes this happen?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. With a move label macro, prevent label from moving onto another label
    By SocratesJC in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-09-2014, 12:34 AM
  2. Replies: 1
    Last Post: 09-30-2013, 09:52 AM
  3. Move data label relatively
    By Serpiente in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-19-2012, 01:24 PM
  4. Data Label to move ahead
    By adyan76 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-21-2009, 10:46 AM
  5. How can I move the series label down below the data?
    By xphiletc in forum Excel General
    Replies: 2
    Last Post: 02-27-2007, 02:29 PM
  6. create macro to move label type data to column data
    By JonathonWood9 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-21-2005, 07:06 PM
  7. Label/data hidden
    By Karsten Pedersen in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-11-2005, 04:06 PM

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