Y-axis title truncated excel 2002

  • Thread starter Thread starter T-Rex
  • Start date Start date
T

T-Rex

I can't get excel 2002 to show the complete y-axis title along the y-axis.
It truncates in the plot whatever I type
in the Chart Options, Value (Y) axis box. No problem with the Chart Title
or X-axis.
Is it worth changing from excel 2002 to excel XP (which I have). I'm running
win2000.
Puzzled.
REX
 
Others have reported this problem. One solution is to add some extra
characters to the y-axis title and to format these to a colour that makes
them invisible on the chart. I have never seen this myself - I use XL2002
and XL2003

best wishes
Bernard
 
I, too, have seen this problem. I just tried your suggestion and it didn't
fix the problem. When I print, the Y label is fully displayed. I have
Excel 2003.
 
Bernard
Thanks. Your fix seems to work...but its touchy about how to apply it. I
kept on experimenting
using a series of periods after a really short title. What shows in excel
and what shows when printed out to a .pdf
appears to be different!
REX
 
See also my response to the thread "Excel does not display all of an axis label"
started by sdthompson, less than two hours after your post.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top