+ Reply to Thread
Results 1 to 5 of 5

How to freeze data label information when you freeze a chart

  1. #1
    Registered User
    Join Date
    05-05-2016
    Location
    Holland
    MS-Off Ver
    2016
    Posts
    23

    How to freeze data label information when you freeze a chart

    Hi people,

    To freeze a filtered XYScatter chart based on a table, I have the simple code underneath, which does the trick for the data.
    I do not want to create an image of the chart, to keep formatting options available.

    Please Login or Register  to view this content.
    However, I would like to freeze the datalabel information as well, to prevent an erroneous reference to the table after releasing the filter.
    To create datalabels, I use:

    Please Login or Register  to view this content.
    But I cannot figure out a way to freeze the datalabel information (in a similar manner).
    Could you help me out?

    Thanks in advance!
    Last edited by max138; 01-10-2018 at 08:16 AM.

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

    Re: How to freeze data label information when you freeze a chart

    I would assume you need to loop through the data labels and set the text.

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    05-05-2016
    Location
    Holland
    MS-Off Ver
    2016
    Posts
    23

    Re: How to freeze data label information when you freeze a chart

    Andy, your code does work, but it is incredibly slow. Is there a way you can do this at once or with arrays?

    Get pretty much always stuck on these datalabels, chartobject chart things. I'm on Excel 2016

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

    Re: How to freeze data label information when you freeze a chart

    Don't see a way of keeping text without looping.

  5. #5
    Registered User
    Join Date
    05-05-2016
    Location
    Holland
    MS-Off Ver
    2016
    Posts
    23

    Re: How to freeze data label information when you freeze a chart

    That's a pitty. Thank you very much for your anwser and time.

+ 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. macro w/ Freeze panes keeps shifting where panes freeze on worksheet
    By sschwant in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2015, 02:30 AM
  2. Freeze Panes - Can I freeze a specific set of cells?
    By Rosco88 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-15-2013, 09:17 AM
  3. Freeze Panes - Freeze Tabs
    By samprince in forum Excel General
    Replies: 1
    Last Post: 01-23-2007, 05:16 PM
  4. Replies: 3
    Last Post: 11-27-2006, 05:24 PM
  5. Excel 2003 freeze panes won't freeze top row only
    By macbone2002 in forum Excel General
    Replies: 1
    Last Post: 05-31-2006, 11:10 AM
  6. Freeze Panes-When freeze panes is employed it leave a black line
    By peter.thompson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2006, 01:40 AM
  7. [SOLVED] Freeze Panes-can you freeze more than one column
    By rexmann in forum Excel General
    Replies: 4
    Last Post: 06-09-2005, 11:05 AM

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