Excel Chart Display problems

Question

I'm having a weird problem with the axis titles on charts in Excel.  When the text is oriented vertically the last few characters are cut off on the screen.  If I rotate the title to horizontal the missing text is there.  When the graph is printed with the text oriented vertically the entire text prints.  Is there any way to get the title box to scale properly?  The same problem also occurs when I try and orient a text box vertically as well.

abach · Answer

Have you searched for an updated printer driver? If not, I'd recommend you install another printer driver and see if the problem is solved. Sometimes printer drivers do not fully show a print preview. You could just install an HP LaserJet model driver, even if you don't have the printer, and see if this works.

chemferrets · Answer

I have the same problem and so far no one can fix it (IT at work, Dell Helpdesk, etc.) Printing is not the problem and changing the screen resolution doesn't help. I'm on a widescreen laptop (Inspiron 6000) with XP Pro and Excel 2000. I've also tried combinations with XP Home and Excel 2000. I've found a few other reports of this problem online with no satifactory solutions, and the computer types aren't listed. Maybe it's a problem between specific monitors/drivers and Microsoft Excel??? I basically bought this laptop for Excel, so this is a real problem for me. Message Edited by chemferrets on 07-20-2005 08:09 PM

abach · Answer

If you would send me a sample, I'll look at it and see if I can solve this riddle...

chemferrets · Answer

I had an unrelated software problem and had to reformat. In the process I discovered that the Excel chart labels were fine before the video driver was installed (ATI MOBILITY RADEON X300), and were truncated afterwards. Running in Safe Mode also fixed the labels, since it uses stripped-down graphics. I would guess there is some type of incompatibility between the video card/driver and Excel.

pmilcak · Answer

Hi, I have the same problem. I use notebook ACER travelmate4500 with wide screen - resolution 1280x800. I found that the resolution is the problem - when I switch to the 1020x768 and restart excel  there is no cut-off problem, but work with this resolution on wide screen is ..... If anybody find any other solution please let me know. I think it is an excel-wide screen bug.

chemferrets · Answer

Restarting Excel after going to low resolution does fix the axis label, but the screen looks horrible. Adding characters to the end of the axis title doesn't always work, even if you add several characters. What works best for me is to replace the y-axis label with a vertical textbox (bottom alignment and no border). Still a pain.

JRosenfeld · Answer

A possible if messy work around is to add one or two characters at the end of the title and set those to white (i.e, background) colour so that they don't show

davwil · Answer

I have the exact problem with my widescreen Acer 1682. I find if I change resolution from 1280x800 to either 1024x768 or preferably 1280x1024, then open excel the whole title text shows. If I now, while excel is still open, revert to the original (1280x800) it is still fine. I can then open any other excel files and the charts are fine. However when excel is closed and opened again the problem recurs

Productivity Software

Was this post helpful?