Excel 2007 - Wrap X-Axis Labels (line break, word wrap)

Question

I am not able to wrap the text of x-axis labels on Excel 2007 charts. As a result, the axis labels are overlapping onto each other. Does anyone know how can I wrap these labels?

Answer 1

After a lot of googling we found CHAR(10) to be the solution of our problems. As long as you have the value like:

="First Line" & CHAR(10) & "Second Line"

it will break X-Axis, Y-Axis, Chart Header etc