I want to remove "(blanks)" from pivot charts in Excel 365. How do I do that?
I have data which contains blanks:
Hdr "a" "a" <blank> "b" "c" This leads to a pivot table like this:
Labels Count of Hdr a 2 b 1 c 1 (blank) And a bar chart like this:
2 I 1 I I I 0 ----------------- a b c (blank) Desired output:
2 I 1 I I I 0 ----------------- a b c So three bars for "a", "b" and "c" respectively but no bar for (blanks).
Image of what I try to achieve
What button/setting do I have to use to achieve this, if at all possible?
Many thanks, Jochem
1 Answer
Filter out "(blank)" row labels in the pivot table by clicking on the little down-facing triangle next to "Row Labels" and un-ticking "(blank)" in the next menu.
