Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 02-05-2024, 02:46 PM
Guessed's Avatar
Guessed Guessed is offline Place data labels of a series outside end at the bottom Windows 10 Place data labels of a series outside end at the bottom Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Marcia

You really don't have enough space for those labels. The titles on each column are already in the position where you want to move the labels so the only space left is when you already have them. Really there isn't enough space for the amount of data you are trying to show.

I think you have a few choices:
1. Make it a Bar chart (horizontal bars) so the text doesn't need rotation and the bars will be longer so the labels on yellow could fit inside the yellow area
2. Merge the smallest values (eg MPDO or smaller) into an 'Others' group so the columns can be wider and you have more space to put text labels
2A. Increase the width of the columns (reducing space between them) to make more space for labels.
3. Drop the text labels from the Expenditures
4. Labels can be moved individually. Click on each one and drag it to where you want it.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
chart data series information in slideshow jonen PowerPoint 0 09-24-2014 01:10 AM
Method to remove overlap in data labels for single series omahadivision Excel Programming 0 12-28-2012 08:55 PM
Powerpoint: adding data to trend lines w/o data labels HaiLe PowerPoint 0 04-11-2011 09:21 AM
Data Series Zach Excel 1 11-05-2010 02:45 PM
i want to place labels on to the left of the page anchored to words within soooty Word 0 07-07-2010 09:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:20 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft