Bar chart X-axis Label truncation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Phil Morrison - 15 Oct 2007 11:49 GMT

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?

Reply to this Message

Andy Pope - 15 Oct 2007 12:15 GMT

Hi,

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

Cheers
Andy

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

>I am using a bar chart and some of the labels on the x-axis (vertical in
>this
[quoted text clipped - 9 lines]
>
> Has anyone found a solution to this problem?

Reply to this Message

Phil Morrison - 16 Oct 2007 10:50 GMT

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?

> Hi,
>
[quoted text clipped - 17 lines]
> >
> > Has anyone found a solution to this problem?

Reply to this Message

Andy Pope - 17 Oct 2007 19:48 GMT

Hi Phil,

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

Cheers
Andy

> Hi Andy, thanks for your posting. I've tried each of the suggestions, but
> unfortunately, none of them do the trick for me!
[quoted text clipped - 22 lines]
>>>
>>>Has anyone found a solution to this problem?

Reply to this Message