Pivot Chart - Displaying a row even when 0 results for it exist in the source data
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I have the following
pivot chart.
It's counting the data from the column in a different tab. The filter options for this column in are displayed here.
Sometimes this column will also contain contain cells that say "High". I want my pivot chart to always display a bar for "High", even when there are 0 results for it (like right now). How can I do this?
microsoft-excel microsoft-excel-2010 microsoft-excel-2007 charts
asked Feb 12 at 2:10
forlornforlorn
103
add a comment |
I have the following
pivot chart.
It's counting the data from the column in a different tab. The filter options for this column in are displayed here.
Sometimes this column will also contain contain cells that say "High". I want my pivot chart to always display a bar for "High", even when there are 0 results for it (like right now). How can I do this?
microsoft-excel microsoft-excel-2010 microsoft-excel-2007 charts
asked Feb 12 at 2:10
forlornforlorn
103
Does your data contain a "High" without any data in the column you are counting?
– Mark Fitzgerald
Feb 12 at 8:19
You could use a helper table maybe? The table will have two columns with 4 rows: 0, Low, Medium and High. Then you can calculate the value usingCOUNTIF, and you then only need to use this table as source for the chart instead of using a pivot table.
– Jerry
Feb 12 at 12:42
add a comment |
I have the following
pivot chart.
It's counting the data from the column in a different tab. The filter options for this column in are displayed here.
Sometimes this column will also contain contain cells that say "High". I want my pivot chart to always display a bar for "High", even when there are 0 results for it (like right now). How can I do this?
microsoft-excel microsoft-excel-2010 microsoft-excel-2007 charts
asked Feb 12 at 2:10
forlornforlorn
103
I have the following
pivot chart.
It's counting the data from the column in a different tab. The filter options for this column in are displayed here.
Sometimes this column will also contain contain cells that say "High". I want my pivot chart to always display a bar for "High", even when there are 0 results for it (like right now). How can I do this?
microsoft-excel microsoft-excel-2010 microsoft-excel-2007 charts
microsoft-excel microsoft-excel-2010 microsoft-excel-2007 charts
asked Feb 12 at 2:10
forlornforlorn
103
asked Feb 12 at 2:10
forlornforlorn
103
asked Feb 12 at 2:10
forlornforlorn
103
asked Feb 12 at 2:10
forlornforlorn
103
asked Feb 12 at 2:10
forlornforlorn
103
103
Does your data contain a "High" without any data in the column you are counting?
– Mark Fitzgerald
Feb 12 at 8:19
You could use a helper table maybe? The table will have two columns with 4 rows: 0, Low, Medium and High. Then you can calculate the value usingCOUNTIF, and you then only need to use this table as source for the chart instead of using a pivot table.
– Jerry
Feb 12 at 12:42
add a comment |
Does your data contain a "High" without any data in the column you are counting?
– Mark Fitzgerald
Feb 12 at 8:19
You could use a helper table maybe? The table will have two columns with 4 rows: 0, Low, Medium and High. Then you can calculate the value usingCOUNTIF, and you then only need to use this table as source for the chart instead of using a pivot table.
– Jerry
Feb 12 at 12:42
Does your data contain a "High" without any data in the column you are counting?
– Mark Fitzgerald
Feb 12 at 8:19
Does your data contain a "High" without any data in the column you are counting?
– Mark Fitzgerald
Feb 12 at 8:19
You could use a helper table maybe? The table will have two columns with 4 rows: 0, Low, Medium and High. Then you can calculate the value using
COUNTIF, and you then only need to use this table as source for the chart instead of using a pivot table.– Jerry
Feb 12 at 12:42
You could use a helper table maybe? The table will have two columns with 4 rows: 0, Low, Medium and High. Then you can calculate the value using
COUNTIF, and you then only need to use this table as source for the chart instead of using a pivot table.– Jerry
Feb 12 at 12:42
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
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%2f1404665%2fpivot-chart-displaying-a-row-even-when-0-results-for-it-exist-in-the-source-da%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
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%2f1404665%2fpivot-chart-displaying-a-row-even-when-0-results-for-it-exist-in-the-source-da%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
Does your data contain a "High" without any data in the column you are counting?
– Mark Fitzgerald
Feb 12 at 8:19
You could use a helper table maybe? The table will have two columns with 4 rows: 0, Low, Medium and High. Then you can calculate the value using
COUNTIF, and you then only need to use this table as source for the chart instead of using a pivot table.– Jerry
Feb 12 at 12:42