+ Reply to Thread
Results 1 to 2 of 2

formatting line labels so they can be seen.

  1. #1
    Forum Contributor
    Join Date
    04-04-2016
    Location
    dallas tx
    MS-Off Ver
    2010
    Posts
    217

    formatting line labels so they can be seen.

    Is there a way to automatically set the chart preferences so that the point labels are posted away from the Line chart so they can be more easily read without having to go in and manually move each one?001.PNG

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    2010 & 2016
    Posts
    5,273

    Re: formatting line labels so they can be seen.

    You can set them all to 'above' which will make it a bit easier. Right click one of the numbers, click format data labels then chose your options.

    If you need them arranged differently, i.e. so some are above, some below, some to the right so you can see them all without the chance of any being obscured by the line, then Excel is sadly missing the "best fit" option I'm afraid.


    BSB
    Last edited by BadlySpelledBuoy; 06-09-2019 at 02:41 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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