 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / September 2006Y axis tilte does not appear properly in Excel
when preparing chart I was adding title for axis, it shows the title properly, after that when I complete the chart the Y axix title does not appear properly, it can not complete the title, for example; my title was "Mean Monthly Simulated Streamflow, cfs" it appeared as "Mean Monthly Simulated Streamflo" or "Mean Month" How can I drag the title or increase the extension of the titile bar? Any help will be appreciated! Thanks In some combinations of monitor (particularly widescreen), screen resolution setting, and window zoom, the Y axis title can be truncated. You can do one of two things: 1. Replace the title (which cannot be resized) with a textbox. 2. Type a few spaces at the end of the title, followed by a non-breaking space, which you get by holding ALT while typing 0160 on the numeric keypad then releasing ALT. These extra spaces are cut off instead of your text. Both of these suggestions are inferior workarounds, but there's nothing better, I'm afraid. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ > when preparing chart I was adding title for axis, it shows the title > properly, after that when I complete the chart the Y axix title does not [quoted text clipped - 4 lines] > How can I drag the title or increase the extension of the titile bar? Any > help will be appreciated! Thanks This problem exists only with MS office 2003 but if I open same excel file in office 2000 it seems alright, I think its a bug or some other problem with office 2003, what do you think? but interestingly I crun Microsoft update it shows Excel is up to date! > In some combinations of monitor (particularly widescreen), screen resolution > setting, and window zoom, the Y axis title can be truncated. You can do one [quoted text clipped - 23 lines] > > How can I drag the title or increase the extension of the titile bar? Any > > help will be appreciated! Thanks Does the same computer have 2000 and 2003? Otherwise there may be differences in video or other settings that cause it to appear one place and not the other. My experience with the problem is mostly anecdotal, which is good news for me. The only time I had this problem consistently on my computer, it was a problem with most zoom settings, most fonts (some worse than others), every workbook I tried, even after I quit and restarted Excel. I don't recall if I tested it on multiple Office versions; if not I tested in 2000. It affected vertically aligned axis titles (Y and X, if I rotated it), as well as vertically aligned textboxes and data labels. I'd never heard of the problem being this severe. Then Windows crashed, I shut down and restarted the computer, and I've never seen it since, at least not on one of my machines. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ > This problem exists only with MS office 2003 but if I open same excel > file [quoted text clipped - 37 lines] >> > Any >> > help will be appreciated! Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.