Google Answers Logo
View Question
 
Q: Truncated Y-Axis Labels on Excel 2003 Charts ( Answered 5 out of 5 stars,   1 Comment )
Question  
Subject: Truncated Y-Axis Labels on Excel 2003 Charts
Category: Computers
Asked by: pete_ca-ga
List Price: $20.00
Posted: 26 Dec 2005 15:27 PST
Expires: 25 Jan 2006 15:27 PST
Question ID: 609935
I have just started using Excel 2003, and am having a problem that
I've not had on  previous versions. When I label the Y Axis (Chart
options... Value (Y) Axis:) the text is truncated. If I use "File" the
end of the e is removed. If I use "File Size" I get "File Siz". That's
about as much as I ever see. If  use "File Size (bytes)" I still see
only "File Siz". I'm using the default text settings, and the text
looks OK in the preview pane as I'm entering it.

Clarification of Question by pete_ca-ga on 26 Dec 2005 21:43 PST
It seems that the knowledgebase article nailed it. I changed my screen
resolution from native (1920 x 1200) to 4:3 (1600 x 1200)and the
problem went away. I find it difficult to believe that MS considers
operating a laptop screen at a non-native resolution to be an
acceptable fix. If you wouldn't mind, could you spend a little longer
looking for a real fix (I checked my video driver and it's
up-to-date). If you find there isn't one, please post your comment as
an answer so you can get paid, and I'll wander off into the distance
muttering under my breath about Microsoft crap.

Thanks.
Answer  
Subject: Re: Truncated Y-Axis Labels on Excel 2003 Charts
Answered By: lotd-ga on 27 Dec 2005 16:29 PST
Rated:5 out of 5 stars
 
Hi pete_ca,

I conducted further research into your problem but unfortunately there
does not seem to be an official fix or patch from Microsoft. The
knowledge base article appears to be Microsoft?s only information on
the issue.

As well as the links I noted in the comments (repeated below), I have
found more news group discussions where the users discuss the problem.

http://support.microsoft.com/default.aspx?scid=kb;en-us;870698

http://groups.google.com/group/microsoft.public.excel.charting/browse_frm/thread/abf8b89d07cc6824

http://groups.google.com/group/microsoft.public.excel.charting/browse_frm/thread/f1f909c569f3840b

http://groups.google.com/group/microsoft.public.excel.charting/browse_frm/thread/83e6ba9a1602b8a1

http://groups.google.com/group/microsoft.public.excel.charting/browse_frm/thread/80a47ee27551857d

http://groups.google.com/group/microsoft.public.excel.charting/browse_frm/thread/d763cef49b0d23d5

?The problem 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 problem seems to go away in print preview and in printed copy.?

Therefore there doesn?t seem to be a straightforward fix. I apologize
for not being able to find a proper fix, but I hope the information
provided is useful.

===============================================

Search Strategy:
://www.google.com/search?q=y+axis+label+excel+truncated


If you require any further clarification, please do not hesitate to ask.

Kind regards,
lotd
pete_ca-ga rated this answer:5 out of 5 stars
Not the answer I was hoping for, but that's hardly the researcher's
fault. I'm amazed that Microsoft can get away with bugs like this year
after year.
Thanks for the speedy and accurate reply.

Comments  
Subject: Re: Truncated Y-Axis Labels on Excel 2003 Charts
From: lotd-ga on 26 Dec 2005 20:03 PST
 
Hi pete_ca,

Please let me know if any of the following links prove to be useful:

http://support.microsoft.com/default.aspx?scid=kb;en-us;870698

http://groups.google.com/group/microsoft.public.excel.charting/browse_frm/thread/abf8b89d07cc6824

http://groups.google.com/group/microsoft.public.excel.charting/browse_frm/thread/f1f909c569f3840b

~lotd

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy