Excel does not display all of an axis label

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When creating a scatterplot in Excel, the y-axis label doesn't display all
the characters. The last character is not shown, or in some cases only the
left half of the character is displayed. I have tried the setting the auto
text sizing on and off, with no effect. This is a recent problem that I have
not had with previous charts. Now, every plot has that problem.
Occassionally using a shorter label fixes the problem, but not always.
Bolding the font seems to prevent the problem. Trouble is I've got lots of
charts without bold and don't want to go back and change them all.
 
This is a frustrating problem, because it occurs sporadically, perhaps due to
differences in hardware configurations and video driver settings. Apparently nobody
really knows. If you have one of those fancy new wide aspect ratio monitors designed
to watch DVD movies, you might be particularly susceptible, unless you reset the
screen resolution to a standard Windows setting (like 1024 x 768).

Other things that I have noticed include the zoom factor, the font itself (I've
never seen it with Arial Narrow, for instance), font size, title length. I've had
trouble replicating the problem myself until a client recently sent me a workbook
which seems particularly sensitive. When I get a chance (ha!), I plan to figure out
some workarounds.

So far, the best you can do is to add a couple spaces, then another character (like
a dot). Then format the last character to match the background color. The spaces and
dot allow the rest of the label to appear on your computer (the dot is truncated),
while hiding it against the background prevents its appearance on a computer without
the problem.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
I neglected to point out that this is a video problem. Although a title is truncated
on screen, it appears normally in print preview and prints out normally.

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