Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Copying charts and their data with relative cell positions | Charts and Charting in Excel | |||
Excel spreadsheets with data, Powerpoint charts... and VBA! | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
Help with pivot charts and data labels | Charts and Charting in Excel |