How do I fix this problem: Y-axis title gets truncated in Excel

R

raf.aerts

If I change the text, font size or bold property in the vertical axis title
text box in a MS Excel XP SP3 chart, usually it gets truncated, showing eg.
"Speed (km/h" instead of "Speed (km/h)". I can fix this by making the title
"Speed (km/h)." so that only the point at the end gets lost, but this is not
a good solution since it shows up again if I export the graph to an EPS for
example. I have noticed a lot of reports with truncated Y-axis graph titles,
so it must be a standard Excel XP bug.
 
B

Barb R.

A workaround to this is to make your Y-axis label read "Speed (km/h) ."
Format the period to be the same color as the background.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel xp truncating text in axis labels 2
How do I extend the Y-axis title? 1
How to resize y-axis chart title? 0
How do I prevent truncation of the Y-axis title? 1
Y-axis title truncated excel 2002 4
Charts-text for x & y axis and titles 5
set y-axis length on chart imported from excel 0
Y- AXIS LABEL IS TRUNCATED in EXCEL CHART ? 0

Top