+ Reply to Thread
Results 1 to 5 of 5

Add and remove data labels buttons

  1. #1
    Registered User
    Join Date
    08-07-2013
    Location
    Cardiff
    MS-Off Ver
    Office 365
    Posts
    86

    Add and remove data labels buttons

    Hi
    I have a dynamic chart, which can have variable number if data series. (Slicer driven).
    I want to create a code so I can click a button which will allow me to add or remove the data labels.

    I can do this by going through each series manually, eg:

    Please Login or Register  to view this content.
    ...and repeat for each data series......

    But how do say ' for this chart, do this for each data series...'?

    Any help would be much appreciated!

  2. #2
    Registered User
    Join Date
    08-07-2013
    Location
    Cardiff
    MS-Off Ver
    Office 365
    Posts
    86

    Re: Add and remove data labels buttons

    Anyone...?

  3. #3
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,256

    Re: Add and remove data labels buttons

    To toggle the datalabels you can use something like:
    Please Login or Register  to view this content.
    Remember what the dormouse said
    Feed your head

  4. #4
    Registered User
    Join Date
    08-07-2013
    Location
    Cardiff
    MS-Off Ver
    Office 365
    Posts
    86

    Re: Add and remove data labels buttons

    Thanks Romperstomper
    This does work, but does not format the text colour etc. Hopefully I'll be able to work that out with your code though.

    Cheers

  5. #5
    Registered User
    Join Date
    08-07-2013
    Location
    Cardiff
    MS-Off Ver
    Office 365
    Posts
    86

    Re: Add and remove data labels buttons

    Sorted!

    I modified the code to tbelow and it does what I want. Thanks again romperstomper!

    Please Login or Register  to view this content.

+ 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. Pie Chart - Remove Zero Value Labels
    By Janc in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 02-22-2018, 06:26 AM
  2. Looping through userform option buttons, textbox and labels
    By Gal403 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-07-2014, 09:03 AM
  3. Hide data labels on the x-axis that represent value of 0 (i.e. remove empty space)
    By lionlunatication in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-24-2013, 10:58 AM
  4. Shrinking text on Excel 2007 command buttons, labels and textboxes
    By csipke in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-25-2012, 09:57 PM
  5. Remove Data Labels on a bar chart if value = 0
    By Grimace in forum Excel General
    Replies: 7
    Last Post: 02-06-2011, 05:32 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