View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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