+ Reply to Thread
Results 1 to 6 of 6

Could not selected Datalabels class

  1. #1
    Registered User
    Join Date
    06-19-2019
    Location
    Viet Nam
    MS-Off Ver
    2016
    Posts
    27

    Could not selected Datalabels class

    Hi Everyone!

    I have recorded macro code to make chart.

    But it has problem after I copy code into the button and then run as attached file.

    I don't know why.

    It might has problem with datalabels property

    Pls suggest to me about this issue.

    Thanks in advance!
    Attached Images Attached Images

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,937

    Re: Could not selected Datalabels class

    Does the data collection with same name still exist? If you copied this macro from and have a new chart the dataset gets a new name (in this case number).
    Go through the macro step by step.
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    06-19-2019
    Location
    Viet Nam
    MS-Off Ver
    2016
    Posts
    27

    Re: Could not selected Datalabels class

    Thanks you.

    The data collection still same... after record macro, I have deleted series which I created by recording macro code. Then I run again macro code and it show error.

  4. #4
    Registered User
    Join Date
    06-19-2019
    Location
    Viet Nam
    MS-Off Ver
    2016
    Posts
    27

    Re: Could not selected Datalabels class

    I have found another way to resolve this issue.

    Thanks you all!

  5. #5
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,937

    Re: Could not selected Datalabels class

    Great, if you would like to share for others to learn?
    Don't forget to mark SOLVED

  6. #6
    Registered User
    Join Date
    06-19-2019
    Location
    Viet Nam
    MS-Off Ver
    2016
    Posts
    27

    Re: Could not selected Datalabels class

    Hi.

    I do not know why, I re-arrange my code in my process only and then it run OKAY ^^

+ 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. Problem displaying datalabels
    By edwardmj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-01-2017, 09:47 AM
  2. “= 1st class’ lower class limit + class width"
    By CheeseFace in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2016, 08:21 PM
  3. How to set zOrder for datalabels in Chart?
    By Mohanv23 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-05-2013, 06:55 AM
  4. Datalabels in chart
    By prefix in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-04-2010, 08:02 AM
  5. Bubble chart datalabels
    By rvExcelNewTip in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-18-2007, 09:25 AM
  6. Selected Method of Range Class Failed
    By nnaida in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-22-2006, 03:50 AM
  7. How to prevent datalabels overlaping each other?
    By Cool Sport in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2005, 06:05 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