+ Reply to Thread
Results 1 to 3 of 3

Is it possible to select all data labels in a series and nudge/move them all at once?

  1. #1
    Forum Contributor
    Join Date
    12-15-2009
    Location
    Herndon, VA
    MS-Off Ver
    Excel 2010
    Posts
    163

    Is it possible to select all data labels in a series and nudge/move them all at once?

    I click on one label, and all labels get selected. This is good. But then when I try to grab them to move all of them, they become deselected except for the one the mouse was over. I want to move them all at once.

  2. #2
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: Is it possible to select all data labels in a series and nudge/move them all at once?

    Hi
    You need to physically select all the Columns using the Ctrl key and then clicking on each column header.
    Hope this helps
    Good luck.
    Tony

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

    Re: Is it possible to select all data labels in a series and nudge/move them all at once?

    You need to do that with code or use add in.

    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)

Similar Threads

  1. Using a Series as Custom Data Labels
    By lmaner in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-25-2012, 04:59 PM
  2. Data labels using values from different series
    By acwall in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-08-2009, 04:11 AM
  3. Data Labels using values from different series
    By acwall in forum Excel General
    Replies: 2
    Last Post: 06-06-2009, 07:23 PM
  4. Hide series data labels?
    By spence425 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-03-2007, 06:58 PM
  5. How can I move the series labels down below the data?
    By xphiletc in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-03-2007, 05:05 AM

Tags for this Thread

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