Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Chart - Data Labels
Is it possible to change the width of the text box for 'Category Name' within
the data label on a chart? I have Category Names which are very long and need to be 'word wrapped', but I cannot change the width of the text box or find a 'word wrap' option for this. Formatting is important as I also need to display the Value, so hard-coding the label is not an option |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Chart - Data Labels
Hi,
Chart data labels are not sizable, even if the handles around them would suggest otherwise. You maybe able to get the breaks in the text you want at fixed places by using ALT+ENTER within the cells that contain the linked text. If you want complete control of formatting you need to use embedded textboxes. The drawback is that they will not automatically re position themselves is the data changes. Cheers Andy Darren L wrote: Is it possible to change the width of the text box for 'Category Name' within the data label on a chart? I have Category Names which are very long and need to be 'word wrapped', but I cannot change the width of the text box or find a 'word wrap' option for this. Formatting is important as I also need to display the Value, so hard-coding the label is not an option |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pie Chart Data Labels | Charts and Charting in Excel | |||
Pie Chart Data Labels | Charts and Charting in Excel | |||
Data labels in Chart | New Users to Excel | |||
Data labels on a stacked chart | Charts and Charting in Excel | |||
Pie Chart Data Labels | Charts and Charting in Excel |