How to remove blanks from pivot chart in Excel 365?
up vote
0
down vote
favorite
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
microsoft-excel office365 pivot-chart
asked Aug 24 at 15:47
Jochem PA
33
add a comment |
up vote
0
down vote
favorite
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
microsoft-excel office365 pivot-chart
asked Aug 24 at 15:47
Jochem PA
33
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
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
microsoft-excel office365 pivot-chart
asked Aug 24 at 15:47
Jochem PA
33
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
microsoft-excel office365 pivot-chart
microsoft-excel office365 pivot-chart
asked Aug 24 at 15:47
Jochem PA
33
asked Aug 24 at 15:47
Jochem PA
33
asked Aug 24 at 15:47
Jochem PA
33
asked Aug 24 at 15:47
Jochem PA
33
asked Aug 24 at 15:47
Jochem PA
33
33
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
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.
answered Nov 27 at 11:59
Jochem PA
33
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
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.
answered Nov 27 at 11:59
Jochem PA
33
add a comment |
up vote
0
down vote
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.
answered Nov 27 at 11:59
Jochem PA
33
add a comment |
up vote
0
down vote
up vote
0
down vote
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.
answered Nov 27 at 11:59
Jochem PA
33
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.
answered Nov 27 at 11:59
Jochem PA
33
answered Nov 27 at 11:59
Jochem PA
33
answered Nov 27 at 11:59
Jochem PA
33
answered Nov 27 at 11:59
Jochem PA
33
33
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1352041%2fhow-to-remove-blanks-from-pivot-chart-in-excel-365%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
