S
Stephanie Krieger
This is a known issue and not a problem with your install.
First (and pardon me if you've tried it, there's more
below) -- but it may be just a matter of your zoom - have
you tried zooming in more tightly? (The accuracy of your
view in Excel, particularly for charts, is greatly
affected by zoom ... and will provide better quality when
you zoom tightly, even if copying the chart, for example,
into a Word document. Zoom fixes many details like this,
including often pie chart label leader lines that appear
to be missing but aren't when you zoom more tightly ...
that sort of thing.)
However, if it's not fixed by zoom -- a workaround is the
answer unfortunately. Instead of fighting with the axis
title (for that workaround, though -- an actual character
or two with white font color applied might be more
effective than spaces), but you might try a linked text
box in place of the axis title instead of messing
manually with the axis title at all -- it's linked to
your data, so it will update just as well when chart data
changes and take any formatting you would want to apply
to any text labels on a chart ... but you can adjust the
size of the text box as needed with ease.
To create a linked text box, click the Text Box icon on
the Drawing toolbar and then click on the chart -- click
into the Formula bar and type an equal sign. If you know
the cell address for the axis title in your data, go
ahead and type it (include sheet reference if
appropriate), or you can browse to and select it once the
equal sign is typed in the formula bar. If the entire
content of the linked cell doesn't appear in your text
box when you press Enter after selecting the cell
reference, just stretch the text box. Double-click on the
text box to format it ... including altering the
orientation of the text box to sit vertically beside your
axis.
Hope that helps.
Stephanie Krieger
author of Microsoft Office Document Designer (from
Microsoft Press)
email: MODD_2003 at msn dot com
blog: arouet.net
First (and pardon me if you've tried it, there's more
below) -- but it may be just a matter of your zoom - have
you tried zooming in more tightly? (The accuracy of your
view in Excel, particularly for charts, is greatly
affected by zoom ... and will provide better quality when
you zoom tightly, even if copying the chart, for example,
into a Word document. Zoom fixes many details like this,
including often pie chart label leader lines that appear
to be missing but aren't when you zoom more tightly ...
that sort of thing.)
However, if it's not fixed by zoom -- a workaround is the
answer unfortunately. Instead of fighting with the axis
title (for that workaround, though -- an actual character
or two with white font color applied might be more
effective than spaces), but you might try a linked text
box in place of the axis title instead of messing
manually with the axis title at all -- it's linked to
your data, so it will update just as well when chart data
changes and take any formatting you would want to apply
to any text labels on a chart ... but you can adjust the
size of the text box as needed with ease.
To create a linked text box, click the Text Box icon on
the Drawing toolbar and then click on the chart -- click
into the Formula bar and type an equal sign. If you know
the cell address for the axis title in your data, go
ahead and type it (include sheet reference if
appropriate), or you can browse to and select it once the
equal sign is typed in the formula bar. If the entire
content of the linked cell doesn't appear in your text
box when you press Enter after selecting the cell
reference, just stretch the text box. Double-click on the
text box to format it ... including altering the
orientation of the text box to sit vertically beside your
axis.
Hope that helps.
Stephanie Krieger
author of Microsoft Office Document Designer (from
Microsoft Press)
email: MODD_2003 at msn dot com
blog: arouet.net