Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    London, Middlesex, England
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel XP Graph's Numbers cut drawn line

    Hello,

    As per the attached screen-shot, you can see how the numbers generated by the XL Chart Wizard cut across the drawn line.

    Is there a way of telling XL to not to that (without manually moving each one) ?

    Bob.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel XP Graph's Numbers cut drawn line

    Rightclick one of the labels, select Format Data Labels, click the ALignment tab and select e.g. Above from the Label Position dropdown.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel XP Graph's Numbers cut drawn line

    If you like to do more things with data labels, like adding labels from another column, download xychartlabeller from http://www.bmsltd.ie/mvp
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    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: Excel XP Graph's Numbers cut drawn line

    Download a copy of Rob Bovey's <img src=/S/free.gif border=0 alt=free width=30 height=15> ChartLabeler. This will allow moving them all at once and to also allow placement where you want them and to use other text as labels.

    Steve

Posting Permissions

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