Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unable to change date format on imported data | Excel Discussion (Misc queries) | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Dynamic update for graph data | Excel Worksheet Functions | |||
ranking query | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |