ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Y axis tilte does not appear properly in Excel (https://www.excelbanter.com/charts-charting-excel/108014-y-axis-tilte-does-not-appear-properly-excel.html)

Rahim

Y 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

Jon Peltier

Y axis tilte does not appear properly in Excel
 
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
_______


"Rahim" wrote in message
...
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




Rahim

Y axis tilte does not appear properly in Excel
 
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!

"Jon Peltier" wrote:

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
_______


"Rahim" wrote in message
...
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





Jon Peltier

Y axis tilte does not appear properly in Excel
 
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
_______


"Rahim" wrote in message
...
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!

"Jon Peltier" wrote:

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
_______


"Rahim" wrote in message
...
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








All times are GMT +1. The time now is 05:18 PM.

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