Excel chart help!!!!!! Please!!!!

A

ant

Heeeeeelp

I have MS excel 2000. Every time I plot a chart the y-axis title (no
labels) is incomplete (a few letters are missing off the end). It doe
not let me change the title-box size via the usual route (i.e. draggin
one of the corners with the mouse). If I change the font size of th
title, the box also gets smaller and some of the title is stil
missing. The x-axis is fine, only the y-axis is causing problems.

The preset title allignment is at 90 degrees, and if I change the titl
allignment to 0 degrees the whole title is visible. So the problem i
only there when I have the y-axis title as vertical and not when it'
horizontal. Furthermore when I change the allignment to minus 9
degrees letters are missing off the opposite end to before.

When I open the same file up on any other computer with the same Exce
version it works fine, the problem only appears on my laptop which i
only 2 months old.

I have tried reinstalling excel but this hasn't worked....

help me please!

Thanks a million.........
 
J

Jon Peltier

This problem seems related to a strange alignment of monitor resolution
and drivers, screen zoom, and the planets' orbits. I don't know whether
some fonts are more susceptible than others. It happens only on some
machines, and on those machines, if you change zoom you might get away
from it (I had a coworker who experienced the problem at 140% but not
139%, or vice versa). It's very frustrating for those who have it,
because a seemingly identical machine can be immune. The only
consolation is that usually the entire label prints fine.

Short of reinstalling video drivers and mucking with monitor settings
and all that, I can only suggest a rather lame workaround. Type your Y
axis label, type a couple spaces, then a period. This is generally
enough extra so the period is cut off, and the full intended label is
present. The period will appear on a computer which doesn't have this
issue, but you can select just the period, and change its font color to
match the background.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top