[Fixed:] Excel Chart Is Not Showing All Data Labels (2 Solutions)

Get FREE Advanced Excel Exercises with Solutions!

Excel Charts are efficient for displaying data trends. Sometimes, for silly reasons, users encounter the Excel Chart not showing all data labels issue. Overall, there are mainly two reasons why Excel Charts don’t show all the data labels. They are:

  1. Incorrect Data Label Reference. 
  2. Same Font and Chart Color and Data Labels’ Position.

Excel Charts may not display all the data labels for any of the above-mentioned reasons.

Excel Chart Not Showing All Data Labels

In this article, we point out the reasons and provide solutions for the Excel Chart not showing all data labels issues.


Download Excel Workbook


2 Easy Solutions If Excel Chart Is Not Showing All Data Labels

Selecting the correct Range to insert data labels and applying different data label Font Colors from the charts with switched data label positions fixes all data labels not showing issue.

Follow the below section to learn more.


Solution 1: Selecting Correct Data Label Reference to Display All Labels

Users normally insert Excel Charts (Insert > Charts) and tick the Data Labels option to display all the data labels. However, some users may use the Value from Cells option to insert the data labels. In that case, they select a partial or incorrect range to insert the data labels. And in the end, they end up looking like the picture below.

Selecting Corrected Data Labels for Excel Charts

Step 1: Click on the chart. The side Menu appears. Click the Plus icon > Data Labels > More Positions.

Step 2: The Format Data Labels side window pops up. You can see the Value from Cells option is ticked. Click on the Select Range.

🔺 Data Label Range dialog box displays the assigned range. And from it, you can say that the range is partial or incorrect.

Step 3: Assign the correct data label range, then click OK.

Corrected Data Labels Reference to Display All Data Labels in Excel Charts

🔺 Finally, Excel inserts all the data labels as it is supposed to, as shown in the image below.

🔺 Alternative to the steps, users can simply display all the data labels by applying Data Callout.

Data Callout

Read More: Data Labels in Excel Pivot Chart (Detailed Analysis)


Similar Readings


Solution 2: Changing Data Label Color and Position to Show All Data Labels

Often, users use the same data label font and chart color unconsciously. Also, they position the data label inside the Charts’ Elements. Therefore, it’s difficult to see the data labels or they are not clearly visible.

Changing the Data Label Color and Position to Show All Data Labels

Step 1: Click on the Plus icon > Data Labels > Choose Outside End.

Step 2: Select all the data labels and then right-click on them. Choose Font from the Context Menu options.

Font Color

Step 3: Excel opens the Font window. Select a color as the Font color (here White is chosen).

Displaying Excel Chart Data Labels in Different Colors

🔺 Selecting a different font color results in displaying all the data labels.

Read More: How to Add Two Data Labels in Excel Chart (with Easy Steps)


Conclusion

This article discusses the probable reasons and demonstrates solutions to resolve Excel Chart not showing all data labels. Users may encounter this issue for any of the above-mentioned reasons. We hope these solutions fix the issue.

Do check out our awesome website, Exceldemy, to find interesting articles on Excel.


Related Articles

Maruf Islam
Maruf Islam

My self, Maruf Islam, an engineer and Excel & VBA Content developer on Exceldemy. I enjoy solving problems, finding workable solutions, and most of the part I really like to take on challenges. On Exceldemy I write articles discussing various way outs of Microsoft Excel's stuck ons.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo