Too long text on Chart Axes - Office 2007

[PetLahev]

Hello

Does anybody know how I can solve problem with too long text on chart axes?

I create charts via VBA and sometimes user writes too long text and Excel doesn't show it in full lenght. Excel truncates it and shows 2 or 3 dots at end of the text. Look at the picture.

I could not figure out how I can find out that text is truncated.

Thanks Premek

 

[Andrew Poulsom]

The problem is discussed here:

http://peltiertech.com/Excel/ChartsHowTo/AxisLabelCutOff.html

Also see:

http://support.microsoft.com/kb/938541

 

[PetLahev]

Thanks a lot Andrew