ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I format the data labels in my stacked bar graph? (https://www.excelbanter.com/charts-charting-excel/102744-how-do-i-format-data-labels-my-stacked-bar-graph.html)

ocjred

How do I format the data labels in my stacked bar graph?
 

Hello,

I am trying to make the Data Labels fit withing the stacked bar graph,
but cannot seem to have any success. I want each label to distribute
itself evenly within the boundries of bar it is labeling. I know that I
can use text box over each bar, but that is a lengthy process and is hit
or miss for me.
Does anyone have any ideas?

Thanks!!!


--
ocjred
------------------------------------------------------------------------
ocjred's Profile: http://www.excelforum.com/member.php...o&userid=37022
View this thread: http://www.excelforum.com/showthread...hreadid=567447


Mark

How do I format the data labels in my stacked bar graph?
 
Right click on any data label you want to work with.

(note: all data labels relating to that series will be selected)

select "Format Data Labels"

select the "Alignment" tab and play around in there.




"ocjred" wrote:


Hello,

I am trying to make the Data Labels fit withing the stacked bar graph,
but cannot seem to have any success. I want each label to distribute
itself evenly within the boundries of bar it is labeling. I know that I
can use text box over each bar, but that is a lengthy process and is hit
or miss for me.
Does anyone have any ideas?

Thanks!!!


--
ocjred
------------------------------------------------------------------------
ocjred's Profile: http://www.excelforum.com/member.php...o&userid=37022
View this thread: http://www.excelforum.com/showthread...hreadid=567447



ocjred

How do I format the data labels in my stacked bar graph?
 

Thanks Mark, but that doesnt seem to work. The data label will still
stay outside the boundries of the graph. Do you have any other ideas?
Thanks.


--
ocjred
------------------------------------------------------------------------
ocjred's Profile: http://www.excelforum.com/member.php...o&userid=37022
View this thread: http://www.excelforum.com/showthread...hreadid=567447



All times are GMT +1. The time now is 08:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com