In some situations, your chart might come with long category names. One disadvantage is that these long names will shrink the chart and make your chart not great. Please follow the steps below to wrap the long names in the Axis:
Step 1: In this example, we use the data in the table below, which contains the fake long category names;
Step 2: Select the data, and make a column chart by click the "Column Chart" from the "Insert" Tab (or check how to make a column chart);
Step 3: By default, you will get the column chart as below.
Obviously, in this chart, the X-Axis took to many spaces. To make the X-Axis take fewer spaces, you can do one or more of the following actions before wrapping them:
- Reduce the Font Size;
- Change the angles.
- Delete some unimportant words;
Step 4: If all the 3 methods do not work, we can wrap them into different lines by using the shortcut "Alt+Enter" in each cell.
Step 3: As we working on the category names, the chart is also changing, if you have customized your chart, there is a chance that this still not show all parts of the name, see below:
Step 4: To show all parts of the names, please double click on X-Axis. In the alignment, change the custom angle to 0 degrees and Text Direction as "Horizontal" (many users may not use this steps if the chart was not customized previously)
Step 5: The full names will show up in the chart with different lines.
That does not always happen. Often the labels are left on one line and overlap. HOW DO YOU FORCE THE LABELS TO WRAP???
Did you try using the shortcut "Alt+Enter" in the excel table the chart based on to break labels into multiple rows first, one by one? Thank you.
Not sure if this will do some help, but how about, after generating the chart, select all the data cells of the intended axis label, and then go to the "Home" tab and unselect (if it is selected) the "Wrap Text" option (in Alignment section) and then select it again. If not selected then just to select it. This selection/un-selection activity is to affect the intended level area as well. This maybe will just wrap into two lines only though which can be adjusted by adjusting text size or the chart area further may be. Hope this helps somehow.