Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 989
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
unable to change date format on imported data Hyerczyk Excel Discussion (Misc queries) 1 July 6th 06 10:33 PM
Inputting data to one worksheet for it effect another daedalus1 Excel Discussion (Misc queries) 1 June 25th 06 04:39 PM
Dynamic update for graph data JRJ Excel Worksheet Functions 2 June 20th 06 10:31 PM
ranking query JaimeTimbrell Excel Discussion (Misc queries) 2 February 16th 06 09:09 AM
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 06:19 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"