Sunday, November 26, 2006

Graph in MS Excel - Y axis title cut off


Problem: While plotting graphs in Excel, Y axis title is always cut off in the middle. Eg: "Expansion" becomes "Expansi"

Solution: This is a bug in Excel and is likely to be fixed in future. There are two ways to overcome this problem.

1. Add the title to a textbox and format the textbox as needed. (Selecting the chart and typing inside will automatically add a textbox to the chart)

2. In the Value for Y axis (Chart options) add the title and append few spaces followed by a period (or any other character). The spaces and the period (or the last character) will be clipped.


4 comments:

Anonymous said...

Thanks!

Anonymous said...

Thank you!

Anonymous said...

Thank you very much. This had been driving me crazy. I had tried just spaces, but it took the period to get it to work.

Alexis said...

Yesterday was wonderful night.But today in the morning I opened my MS Excel and couldn't read my files.Fortunately a friend recommended-.xls files repair.Tool helped me very quickly and free of charge.Moreover I saw how tool recover worksheets in Microsoft Excel format.

Back to Top


 

Labels