How to keep chart text from wrapping

[Skysurfer]

Hi,

I have created a chart where the data points have long text labels (such as "Phase II Development" and "Web Site Development"). Each of the labels is linked to a particular cell. The problem is that Excel automatically wraps the text labels within the boxes. Sometimes it looks appropriate. Sometimes not so much.

I've tried selecting individual text boxes to widen them. But Excel doesn't seem to allow me to resize them.

Is there any way to prevent text from wrapping without having to create a freehand text box outside of the chart? Or a way to resize those text boxes?

Lawrence

 

[Mentally_Hilarious]

I thought I'd bump this, rather than writing a new thread. I've got the same issue. It wouldn't be a problem if it was wrapping usefully, but it's putting the last letter of the label on the next line!!

I've tried the search, tried the help, throttled the monitor and nothing seems to work. Although the office would prefer it if I stopped swearing at my computer.

Any thoughts?

 

[mcontr]

I am having this problem. What I have found is that it is a Excel 2010 issue where the Format Data Labels > Alignment> Wrap text in shape is grayed out. I read that it is not grayed out in 2013 version of excel.
What I don't know is how to fix this in 2010. I have alot of graphs and it always wraps the last number down to the next line. I heard that it might be able to be fixed in writing some VBA code but I am not sure how to write this.
If anyone has a suggestion on how to fix this other than inserting a text box, I would love to hear it.