Re: Truncated "y" axis label in chart

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi

This is a known problem and, last I heard, hadn't been properly fixed. I
posted a similar question in July 04 ('clipping of y-axis label') and this
was Jon Peltier response:

"This is due to a combination of font size, zoom factor, screen resolution,
and a few other monitor related parameters ("pixel aspect
ratio"). It's frustrating because it isn't really predictable, and it isn't
easy to get rid of.

The standard workaround suggested here is to append a couple spaces and a
period after the title text. Hide the period for those without this
problem by formatting the last character's font color to match the
background. Another option is to put the desired text into a text box
formatted the way the title would have been.

I understand that Microsoft is preparing an article for the knowledge base
relating to this problem. I don't believe there's a more satisfying
workaround than the one I just described"

I haven't checked whether the KB article has now appeared. If is has,
I'msure someone will give a pointer to it.

HTH, Phil






"flakkortin" <flakkortin.1sckeb_1121659501.8859@xxxxxxxxxxxxxxxxxxxxx> wrote
in message news:flakkortin.1sckeb_1121659501.8859@xxxxxxxxxxxxxxxxxxxxxxxx
>
> :confused: Hi guys
> I have a problem with Excel, the label on the "Y" axis appears
> truncated even though I have resized the chart. Then, I looked the file
> in another computer with the same version of excel than mine as well as
> in another with a different version and in both look fine. Thus, I
> erased and re-installed excel in my computer to no avail. I have also
> re-sized the chart and used it both as object embedded and in separate
> ***, it doesn't fix the problem. Any suggestions to fix this problem?
>
>
> --
> flakkortin
> ------------------------------------------------------------------------
> flakkortin's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=25305
> View this thread: http://www.excelforum.com/showthread.php?threadid=387911
>


.

Quantcast