How to rezize data label box in pie charts (label wraps to two lin
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. |
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 |
All times are GMT +1. The time now is 07:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com