On Wed, 16 Aug 2006, in microsoft.public.excel.charting,
niccig said:

My x axis labels are very long, up to 70 characters. I wish I could
shorten these, but they have already been published by previous
authors. We have to use what was published.

I can't get the entire text to show. I've tried changing the size of
the font or the text direction. I've also tried resizing the plot
area, but the amount of space allowed for the x-axis labels is fixed.
I've made the plot area very small, and the text is still cut off at
the exact same point when the plot area was larger. In normal view, I
can see the entire text, but when it prints, it's cut off.

Any suggestions? This is driving me nuts!

Annoying isn't it? I'm getting the same thing with y-axis labels on
horizontal bar charts, and when experimenting with Excel chart hacks
like bullet graphs, dot plots etc.

I think you're just going to have to bite the bullet and create a key:
shorten the titles into some sort of mnemonic code, and then place a
table nearby to explain the code, giving the full 70 character
descriptions.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.