Resize Data Labels

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PivotChart resizing problem 2
Excel Chart Presentation 1
Data Labels Disappearing 0
How do I resize a check box (Control box) in Excel 1
How do I insert and resize a column on only one worksheet page? 4
resizing individual cells 1
Resize tabs in Excel 3
How do I resize a data label box in a pie chart to stop text wrapp 1

Back
Top