Resize Data Labels
How do I resize data labels within a graph? I know how to resize the font,
but I need to know how to put the contents of the label on one line opposed to two. I cant seem to figure out how to resize the actual label. |
Resize Data Labels
Hi,
Basically you can't. You can not control the width or height of a data label other than by insert new line characters or adjusting fontsize. If you want complete control you need to use a textbox embedded within the chart object. This can be linked to cells if the content is dynamic. To add a textbox to a chart just select the chart and then type =Sheet1!A1 or the complete address of the cell you want to link to. If you do not need the link just type the text and when you press Return a textbox will be created. Cheers Andy daywata wrote: How do I resize data labels within a graph? I know how to resize the font, but I need to know how to put the contents of the label on one line opposed to two. I cant seem to figure out how to resize the actual label. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
All times are GMT +1. The time now is 09:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com