Resize chart data label

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

Guest

Hi, I have chart data labels that are displaying as one line in Excel but
push over into two lines when paste/linked into a PowerPoint slide. Is there
some way to force the labels to stay on one line? And as a general matter,
is it possible to manipulate the size of the box containing the data label at
all? I can select it but can't seem to resize manually. I also looked for
info on this in VBA help but couldn't find anything.

Any help would be appreciated.

Kind regards,
Don
 
Don -

You cannot resize a data label, an axis title, or a chart title, even
though it looks like a real text box with eight little resizing handles
when it's selected. This is the case manually and programmatically (VBA).

A common workaround is to remove the pseudo textbox with a real textbox.
The easiest way to get a textbox into the chart is to select the chart's
plot area or chart area and just start typing. Whatever you type will be
placed into a newly created textbox in the middle of the chart, ready
for you to format and position. To link a new textbox to a worksheet
cell, select the chart (as before), type the equals key, then select the
cell. The formula bar shows the cell link, =Sheet1!$A$1.

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

This workaround is fine for us. Thanks very much for your help.

Kind regards,
Don
 
Back
Top