Data Labels

G

Guest

I have two data labels that overlap on a chart. Is there a way to wrap text
or change the data label box sizing so I can see both labels?

Help please

Cody
 
J

Jon Peltier

Cody -

Unfortunately you don't have a lot of control over the data labels. They
look like text boxes, but the little black handles are merely
decoration, and do not allow resizing.

You can move a label: click on the label to select the series of labels,
then click again to select the single label. Drag the label by its edges
to a new position.

You can edit the text of the label: click on the label to select the
series of labels, then click again to select the single label. Click a
third time to activate the cursor within the label. Insert carriage
returns where appropriate to adjust the width of the label.

You can replace a label by a text box. The easiest way to insert a
textbox is to select the chart and type whatever label you want. When
you press Enter, Excel puts a new textbox in the middle of the chart
with the text you just typed.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

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

Top