How to Warp X-Axis labels in Excel

This post will guide you how to wrap the text of x-Axis labels on Excel Charts. How do I wrap x axis labels in a chart in Excel 2013/2016.

Warp X Axis Labels


Assuming that you have created a column chart with relatively long labels on X axis the program by default puts the label in one line. And the axis labels are overlapping onto each other. So you may be want to warp axis labels in your chart. How to force the Excel to wrap x-axis labels in your chart. Just do the following steps:

warp x axis label1

Step1: select one label cell in your source data (such as: Cell A2), and replace the original label with the following formula:

=”excel”&CHAR(10)&”2013″

Step2: you would see that all X axis labels have been wrapped.

warp x axis label2

Note: you can also add a line break in your label cell with ALT + ENTER shortcut, it will also be reflected in your chart to warp X-Axis labels.

Related Functions


  • Excel CHAR function
    The Excel CHAR function returns the character specified by a number (ASCII Value). The syntax of the CHAR function is as below: =CHAR(number)….
Related Posts

Calculate The Period of Loan or Investment in Excel

In our daily life, most of us will invest or take a loan, so we need to master some simple financial functions to calculate the period needed for loans or investments. If you work as an accountant, you need to ...

Working Time Calculation Based on Timesheets

In the office, a special machine record the time when you start working (clock in office) and when you finish working (clock out of office). We can calculate the total working time by subtracting the end working time from the ...

Repeating Character n Times in Excel
Repeating Character n Times in Excel1

In daily life, we can use repeated characters to indicate the magnitude or priority of something. For example, a single “!” indicates a minor case, double “!!” indicates a medium case, and triple “!!!” indicates a high case, and so ...

Insert Line Break
insert line break

If you have ever used MS Word or MS Powerpoint, you must be familiar that in them both, you can insert a line break by simply pressing the "Enter" key from your keyboard. We don't give any attention to this ...

Extract Multiple Lines From A Cell

Suppose that you have listed some text in a single cell which is separated by the line break(you can do it by pressing ALT + ENTER after entering the text), and now you want to extract multiple lines of text ...

How to Add Quotes around Cell Values in Excel
Add Quotes around Cell Values3

This post will guide you how to add double quotes around cell values with a formula in your worksheet in Excel. How do I add quotes around each value of cells in Excel 2013/2016. How to add double quotes inside ...

How to Remove Specific Character from Text Cell in Excel
remove specific character from text string6

This post will guide you how to remove a specific character from text cell in Excel. How do I remove certain character from a cell with a formula in Excel 2013/2016. Remove Specific Character Using Find and Replace function Remove ...

How to Concatenate Data with a Line Break in Excel

This post will guide you how to combine multiple cells with line break in Excel. How do I concatenate cells with a line break character into one cell with formula in Excel. Concatenate Data with Line Break Character You can ...

How to Remove Line Breaks (Carriage Returns) in Excel
remove line breaks9

This post will explain that how to remove line breaks in your data set in Excel. How do I remove carriage returns or line breaks with a formula in Excel. How to remove line breaks with VBA Macro in Excel. ...

Generate Random Character Strings
generate random strings9

This post will guide you how to generate a random character string in excel. How do I create a random passwords, text strings with a formula in excel. How do I generate random strings of characters with VBA code in excel. ...

Sidebar