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

excel-2007
soldieraman picture soldieraman · Nov 10, 2010 · Viewed 44.8k times · Source

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

soldieraman picture soldieraman · Aug 23, 2011

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

Related questions

Append same text to every cell in a column in Excel

How can I append text to every cell in a column in Excel? I need to add a comma (",") to the end. Example: [email protected] turns into [email protected], Data Sample: [email protected] satishmm_2sptc@…

Read More
How do I convert a column of text URLs into active hyperlinks in Excel?

I have a column in excel, wherein I have all the website url values. My question is I want to turn the url values to active links. There are about 200 entries in that column with different urls in all cells. …

Read More
How to do a "Save As" in vba code, saving my current Excel workbook with datestamp?

I have an Excel Workbook that on form button click I want to save a copy of the workbook with the filename being the current date. I keep trying the the following ActiveWorkbook.SaveAs ("\\filePath\FormFlow To MSExcel\" & Left(…

Read More