Menu
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?
648
Wrapping Labels Simply place your cursor in the formula bar where you want to add the break and press the ALT+ENTER keys. Hit ENTER again, and you'll see the text wrap on two lines. You now have the text arranged the way you like it in the spreadsheet and in the graph.
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
77
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With