# Excel Pivot Chart - Data lables question

**URL:** <https://boards.straightdope.com/t/excel-pivot-chart-data-lables-question/607840>\
**Category:** Factual Questions\
**Created:** [December 30, 2011, 4:05pm UTC](https://boards.straightdope.com/t/excel-pivot-chart-data-lables-question/607840 "2011-12-30T16:05:21Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![35\_U.S.C](https://avatars.discourse-cdn.com/v4/letter/3/a4c791/32.png) [@35\_U.S.C](https://boards.straightdope.com/u/35_U.S.C)\
**Post date:** [December 30, 2011, 4:05pm UTC](https://boards.straightdope.com/t/excel-pivot-chart-data-lables-question/607840/1 "2011-12-30T16:05:21Z")

</div>

All,

I’ve got a pivot chart in excel 2010. It is a bar chart with several groupings. If I drill down into any grouping, only 1 of the members of that subgroup will show data labels above each bar. This occurs regardless of how far down I drill. If I click on a series, it will actually highlight the exact space where the label SHOULD be in the label-less grouping, along with the same correctly-labeled spots in the other groups. It has nothing to do with font color, or anything like that, but i’m completely stuck. Does anyone have any ideas as to how I can force all labels to display at once?

Thanks!