Bar chart X-axis Label truncation

[Phil Morrison]

I am using a bar chart and some of the labels on the x-axis (vertical in this
case) are truncating (the last word or two of the label are not being
dispalyed). This is occurring when I use 'paste special (values)' to paste
different data (and data labels in a different order) into the correct range
of cells.

I have tried changing font size, style etc. I have tried changing screen
resolution without success.

Has anyone found a solution to this problem?

 

[Andy Pope]

Hi,

More information on truncated labels, which may help.
http://peltiertech.com/Excel/ChartsHowTo/AxisLabelCutOff.html

Cheers
Andy

 

[Phil Morrison]

Hi Andy, thanks for your posting. I've tried each of the suggestions, but
unfortunately, none of them do the trick for me!

Any other suggestions?

 

[Andy Pope]

Hi Phil,

If you want to email the offending file I will see take a look.
What version of xl you using?

Cheers
Andy