ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Axis label question (https://www.excelbanter.com/charts-charting-excel/131003-axis-label-question.html)

Vrin

Axis label question
 
Hi all,
Using Excel 2003, often the last few characters of the value (Y) axis label
are not displayed when creating a data chart. Does anyone know how to fix
this
problem? I've sometimes been able to force it to display the last characters
by adding a couple spaces at the end of the axis title, but this is not an
ideal solution and doesn't always work.

Any and all suggestions are welcomed.

Thank you!
Vrin


Bernard Liengme

Axis label question
 
This is a known bug and your solution seems the prefered workaround. If your
file goes to other, you may wish to format the added characters to make them
invisible since the bug occurs only on some PCs
best wishes
Bernard Liengme
http://people.stfx.ca/bliengme/


"Vrin" .(donotspam) wrote in message
...
Hi all,
Using Excel 2003, often the last few characters of the value (Y) axis
label
are not displayed when creating a data chart. Does anyone know how to fix
this
problem? I've sometimes been able to force it to display the last
characters
by adding a couple spaces at the end of the axis title, but this is not an
ideal solution and doesn't always work.

Any and all suggestions are welcomed.

Thank you!
Vrin



Mike Middleton

Axis label question
 
Vrin -

Instead of adding only spaces, you may need to include a printable
character, like a period, after the spaces.

But, to see the variety of solutions to this problem, browse to
www.google.com or to groups.google.com and search for "excel truncated y
axis label" (without the quotes).

- Mike
http://www.mikemiddleton.com


"Vrin" .(donotspam) wrote in message
...
Hi all,
Using Excel 2003, often the last few characters of the value (Y) axis
label
are not displayed when creating a data chart. Does anyone know how to fix
this
problem? I've sometimes been able to force it to display the last
characters
by adding a couple spaces at the end of the axis title, but this is not an
ideal solution and doesn't always work.

Any and all suggestions are welcomed.

Thank you!
Vrin




Vrin

Axis label question
 
Hi Mike,

Thanks for the reply. I've added a period before, not always with success,
mostly because I didn't think to change the font color to white. I
appreciate your suggestion to search on Google - I found some more info
there. Guess I'll just have to wait until the company updates to 2007 - I
won't hold my breath given we just last month updated to 2003.

Thanks,
Vrin

"Mike Middleton" wrote:

Vrin -

Instead of adding only spaces, you may need to include a printable
character, like a period, after the spaces.

But, to see the variety of solutions to this problem, browse to
www.google.com or to groups.google.com and search for "excel truncated y
axis label" (without the quotes).

- Mike
http://www.mikemiddleton.com


"Vrin" .(donotspam) wrote in message
...
Hi all,
Using Excel 2003, often the last few characters of the value (Y) axis
label
are not displayed when creating a data chart. Does anyone know how to fix
this
problem? I've sometimes been able to force it to display the last
characters
by adding a couple spaces at the end of the axis title, but this is not an
ideal solution and doesn't always work.

Any and all suggestions are welcomed.

Thank you!
Vrin





Vrin

Axis label question
 
Hi Bernard - Thanks for your reply. Guess I'll have to wait until my company
updates to 2007, but until then I'll continue with my workaround. Bummer.

Thanks,
Vrin

"Bernard Liengme" wrote:

This is a known bug and your solution seems the prefered workaround. If your
file goes to other, you may wish to format the added characters to make them
invisible since the bug occurs only on some PCs
best wishes
Bernard Liengme
http://people.stfx.ca/bliengme/


"Vrin" .(donotspam) wrote in message
...
Hi all,
Using Excel 2003, often the last few characters of the value (Y) axis
label
are not displayed when creating a data chart. Does anyone know how to fix
this
problem? I've sometimes been able to force it to display the last
characters
by adding a couple spaces at the end of the axis title, but this is not an
ideal solution and doesn't always work.

Any and all suggestions are welcomed.

Thank you!
Vrin



Jon Peltier

Axis label question
 
Don't be in a hurry to upgrade. Better the devil you know...

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Vrin" .(donotspam) wrote in message
...
Hi Mike,

Thanks for the reply. I've added a period before, not always with
success,
mostly because I didn't think to change the font color to white. I
appreciate your suggestion to search on Google - I found some more info
there. Guess I'll just have to wait until the company updates to 2007 - I
won't hold my breath given we just last month updated to 2003.

Thanks,
Vrin

"Mike Middleton" wrote:

Vrin -

Instead of adding only spaces, you may need to include a printable
character, like a period, after the spaces.

But, to see the variety of solutions to this problem, browse to
www.google.com or to groups.google.com and search for "excel truncated y
axis label" (without the quotes).

- Mike
http://www.mikemiddleton.com


"Vrin" .(donotspam) wrote in message
...
Hi all,
Using Excel 2003, often the last few characters of the value (Y) axis
label
are not displayed when creating a data chart. Does anyone know how to
fix
this
problem? I've sometimes been able to force it to display the last
characters
by adding a couple spaces at the end of the axis title, but this is not
an
ideal solution and doesn't always work.

Any and all suggestions are welcomed.

Thank you!
Vrin







Vrin

Axis label question
 
Good point! I'll keep that in mind.

Thanks!
Vrin

"Jon Peltier" wrote:

Don't be in a hurry to upgrade. Better the devil you know...

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Vrin" .(donotspam) wrote in message
...
Hi Mike,

Thanks for the reply. I've added a period before, not always with
success,
mostly because I didn't think to change the font color to white. I
appreciate your suggestion to search on Google - I found some more info
there. Guess I'll just have to wait until the company updates to 2007 - I
won't hold my breath given we just last month updated to 2003.

Thanks,
Vrin

"Mike Middleton" wrote:

Vrin -

Instead of adding only spaces, you may need to include a printable
character, like a period, after the spaces.

But, to see the variety of solutions to this problem, browse to
www.google.com or to groups.google.com and search for "excel truncated y
axis label" (without the quotes).

- Mike
http://www.mikemiddleton.com


"Vrin" .(donotspam) wrote in message
...
Hi all,
Using Excel 2003, often the last few characters of the value (Y) axis
label
are not displayed when creating a data chart. Does anyone know how to
fix
this
problem? I've sometimes been able to force it to display the last
characters
by adding a couple spaces at the end of the axis title, but this is not
an
ideal solution and doesn't always work.

Any and all suggestions are welcomed.

Thank you!
Vrin








All times are GMT +1. The time now is 09:17 PM.

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