Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Voorhees, New Jersey
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    moving plot labels (2003 SP3)

    is there a way to do a block move of all data labels on an excel plot...

    For instance, they all appear to the right of their respective data points and I want to re-position them all simultaneously so that they are to the left...

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: moving plot labels (2003 SP3)

    Dbl-click one of the labels to pull up the "format datalabels dialog"
    In the Alignment(tab) there is a pulldown for "Label position". Select "Left" rather than right, tehn <ok>

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Voorhees, New Jersey
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: moving plot labels (2003 SP3)

    Steve,

    Thanks!

    Tom

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •