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
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
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks