When creating a pie chart and adding data labels to the slices, the wording can sometimes split into two lines—giving you wrapped data labels that aren’t visually appealing. In the below example, Administration has been split into two words, each on a separate line. The labels are wrapped and the results appear incorrectly.
Applies To: Microsoft® Excel® for Windows 2013 and 2016.
You are welcome to download the workbook to practice.
This issue is easily resolved, by simply turning off word-wrapping:
1. Right click on the data label and select Format Data Labels
2. Select Text Options > Text Box > and un-select Wrap text in shape.
3. The data labels resize to fit all the text on one line.
4. Alternatively, by double-clicking a data label, the handles can be used to resize the label to wrap words as desired.
This can be done on all data labels or on an individual slice data label. It also ensures that the labels are correctly displayed on the chart.
The post How to fix wrapped data labels in a pie chart appeared first on Sage Intelligence.
Powered by WPeMatico