If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help, I can't resize chart legends on my axes or titles
I only have this problem on this machine. Things work fine on all others
Running Office 2003 (SP2) on XP Pro (SP2) on an Inspiron 9300. When I enter text into chart legends, it gets clipped and when I click on the frame, Excel won't let me drag the frame wider. What could be causing this? If I copy the file to another computer and reopen, it's fine, everything works, but if I copy it back the problem immediately returns. I've run the update for Excel, I've updated my video drivers, nothing works. |
#2
|
|||
|
|||
Help, I can't resize chart legends on my axes or titles
My apologies for taking up anyone's time. This problem has apparently been
"solved" about a hundred times already. In case anyone missed it (like I did), see KB870698. wide-screen monitors with 16:10 aspect ratios cause this problem. Microsoft knows about it and Dell and everyone else keep selling widescreen monitors so we can do spreadsheet work. As usual, the customer gets screwed. A shame really, because it's probably a ten minute coding job to fix it. If you've gotta use the wide screen, pad the text string with extra spaces and a period at the end. This will trick Excel into showing the whole string. The alternative (setting your monitor to 1024 X 768) will disappoint and aggravate you. "XYZZYX59" wrote: I only have this problem on this machine. Things work fine on all others Running Office 2003 (SP2) on XP Pro (SP2) on an Inspiron 9300. When I enter text into chart legends, it gets clipped and when I click on the frame, Excel won't let me drag the frame wider. What could be causing this? If I copy the file to another computer and reopen, it's fine, everything works, but if I copy it back the problem immediately returns. I've run the update for Excel, I've updated my video drivers, nothing works. |
#3
|
|||
|
|||
Help, I can't resize chart legends on my axes or titles
Pad the string with spaces and a nonbreaking space: hold Alt while pressing
0160 on the numeric keypad. Then you don't have to worry about the period showing on a normal monitor. Note: this problem has existed long before the high AR monitors. It can also be related to drivers, font sizes, window zoom, and apparently high tide cycles. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "XYZZYX59" wrote in message ... My apologies for taking up anyone's time. This problem has apparently been "solved" about a hundred times already. In case anyone missed it (like I did), see KB870698. wide-screen monitors with 16:10 aspect ratios cause this problem. Microsoft knows about it and Dell and everyone else keep selling widescreen monitors so we can do spreadsheet work. As usual, the customer gets screwed. A shame really, because it's probably a ten minute coding job to fix it. If you've gotta use the wide screen, pad the text string with extra spaces and a period at the end. This will trick Excel into showing the whole string. The alternative (setting your monitor to 1024 X 768) will disappoint and aggravate you. "XYZZYX59" wrote: I only have this problem on this machine. Things work fine on all others Running Office 2003 (SP2) on XP Pro (SP2) on an Inspiron 9300. When I enter text into chart legends, it gets clipped and when I click on the frame, Excel won't let me drag the frame wider. What could be causing this? If I copy the file to another computer and reopen, it's fine, everything works, but if I copy it back the problem immediately returns. I've run the update for Excel, I've updated my video drivers, nothing works. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to resize a entire chart with text, etc. to smaller size ? | Graphic05 | General Discussion | 0 | August 3rd, 2005 07:28 PM |
Scaled Chart Axes | patrick | Charts and Charting | 1 | March 19th, 2005 01:35 AM |
Centering Axis and Chart Titles on chart | saturnin02 | General Discussion | 1 | February 9th, 2005 09:28 AM |
Chart axis titles cannot be resized using the handles and last ch. | Sanglea | Charts and Charting | 3 | September 22nd, 2004 09:35 PM |
Styles for chart | Debra Dalgleish | Charts and Charting | 1 | October 3rd, 2003 12:27 PM |