ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Help, I can't resize chart legends on my axes or titles (https://www.excelbanter.com/charts-charting-excel/76818-help-i-cant-resize-chart-legends-my-axes-titles.html)

XYZZYX59

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.

XYZZYX59

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.


Jon Peltier

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.





All times are GMT +1. The time now is 10:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com