+ Reply to Thread
Results 1 to 2 of 2

formatting line labels so they can be seen.

  1. #1
    Forum Contributor
    Join Date
    dallas tx
    MS-Off Ver

    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
    East Sussex
    MS-Off Ver
    2010 & 2016

    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.

    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)


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