View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default How to rezize data label box in pie charts (label wraps to twolin

Hi,

The bounding boxes on chart text are mis-leading as the height and width
property can not be adjusted, either manually or via code.

The size of the boxes is determined internally by the charting engine
dependent on things such as font size, text length, chart size.
You can add line feeds to the text to at least have wrap occur where you
want but this will not stop extra ones being added.

No real solution other than to reduce the font size and text in order to
stop automatic wrapping. Or perhaps an alternative chart type.

Cheers
Andy

rolliedogg wrote:
When creating a pie chart in Excel then pasting into Powerpoint, I have
trouble getting the data lablels to look ok. Often times the font is so
small it can't be read. When you increase the font size, often a the label
such as "October Sales" would be pushed to 2 lines with "October Sa" on the
first line. When you select the label, a box appears around the words, but
it can not be resized, to get the label back to one line. My work around
has been to delete all the label info and leader lines and then to retype the
info using drawing/text boxes. Problem is the text boxes are not related to
the pie chart and any changes to the pie chart data is not carried over to
the new text boxes.

Hope this all makes sense.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info