I've added a couple of spaces and a period to "fix" this and then format the
period so that it's the same color as the background. Unfortunately, I've
had difficulty doing even that lately.

"David Burr" wrote in message
...
I would be grateful if someone could help me with this problem as despite
throwing a lot of time at it I cannot seem to find a solution.

I have a horizontal bar chart with labels against the side axis. The
labels are being truncated.

Is there a way to force Excel to devote more space to the labels and less
to the chart? As I resize the chart it doesn't seem to allow me to devote
more space to the labels.

At one stage in desparation I considered using a text box to display the
labels. However having separate text boxes for each of the 30 different
data points on 8 different charts just isn't workable. If I could find a
way of having just one text box for each chart and setting the contents of
the box to equal the values in the spreadsheet that would I guess be ok.
The problem I had was inserting carriage returns so that each label would
appear on a new line in the text box. I couldn't crack that so I went back
to trying to resize the width of the chart labels relative to the chart
itself.

Many thanks for any help


David Burr