Include non-existent data elements in pivot chart WITHOUT dummy data

up vote
0
down vote

favorite

This is similar to this question here:

Excel Pivot chart - displaying values not in the source data

However, that answer suggests to provide dummy data which I do not want to do due to the large set of data I am working with.

Let's assume I have the following dataset:

enter image description here

It's missing data for days Wed and Sun, so it generates a pivot chart like this (mind the sort order of the days):

enter image description here

However, I want it to look like this:

enter image description here

As suggested in the linked answer above, I was only able to achieve the second result by adding dummy data. That's easy for the simple recordset I am using here, but it's not practical for recordsets with tens of thousands of records with inconsistently missing data for ranges of hours. Therefore, I am hoping there is a way to provide the pivot chart with a "phantom series range" that contains a full range of key data, but just displays a 0 value in the chart if there are no data elements for it.

asked Nov 23 at 22:13

oscilatingcretin

1,955215995

Does you data have something else than just days of the week (Mon, Tue, Wed, etc...) If no, how do you "know" that a given Tuesday is five days after a given Friday (and not 12 or 19). If you have actual dates, you can set the axis to display dates
– cybernetic.nomad
Nov 23 at 22:24

add a comment |

up vote
0
down vote

favorite

This is similar to this question here:

Excel Pivot chart - displaying values not in the source data

However, that answer suggests to provide dummy data which I do not want to do due to the large set of data I am working with.

Let's assume I have the following dataset:

enter image description here

It's missing data for days Wed and Sun, so it generates a pivot chart like this (mind the sort order of the days):

enter image description here

However, I want it to look like this:

enter image description here

asked Nov 23 at 22:13

oscilatingcretin

1,955215995

Does you data have something else than just days of the week (Mon, Tue, Wed, etc...) If no, how do you "know" that a given Tuesday is five days after a given Friday (and not 12 or 19). If you have actual dates, you can set the axis to display dates
– cybernetic.nomad
Nov 23 at 22:24

add a comment |

up vote
0
down vote

favorite

This is similar to this question here:

Excel Pivot chart - displaying values not in the source data

However, that answer suggests to provide dummy data which I do not want to do due to the large set of data I am working with.

Let's assume I have the following dataset:

enter image description here

It's missing data for days Wed and Sun, so it generates a pivot chart like this (mind the sort order of the days):

enter image description here

However, I want it to look like this:

enter image description here

asked Nov 23 at 22:13

oscilatingcretin

1,955215995

This is similar to this question here:

Excel Pivot chart - displaying values not in the source data

However, that answer suggests to provide dummy data which I do not want to do due to the large set of data I am working with.

Let's assume I have the following dataset:

enter image description here

It's missing data for days Wed and Sun, so it generates a pivot chart like this (mind the sort order of the days):

enter image description here

However, I want it to look like this:

enter image description here

microsoft-excel microsoft-excel-2007

asked Nov 23 at 22:13

oscilatingcretin

1,955215995

asked Nov 23 at 22:13

oscilatingcretin

1,955215995

asked Nov 23 at 22:13

oscilatingcretin

1,955215995

asked Nov 23 at 22:13

oscilatingcretin

1,955215995

asked Nov 23 at 22:13

oscilatingcretin

1,955215995

Does you data have something else than just days of the week (Mon, Tue, Wed, etc...) If no, how do you "know" that a given Tuesday is five days after a given Friday (and not 12 or 19). If you have actual dates, you can set the axis to display dates
– cybernetic.nomad
Nov 23 at 22:24

add a comment |

Does you data have something else than just days of the week (Mon, Tue, Wed, etc...) If no, how do you "know" that a given Tuesday is five days after a given Friday (and not 12 or 19). If you have actual dates, you can set the axis to display dates
– cybernetic.nomad
Nov 23 at 22:24

Does you data have something else than just days of the week (Mon, Tue, Wed, etc...) If no, how do you "know" that a given Tuesday is five days after a given Friday (and not 12 or 19). If you have actual dates, you can set the axis to display dates
– cybernetic.nomad
Nov 23 at 22:24

add a comment |

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',
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
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1377896%2finclude-non-existent-data-elements-in-pivot-chart-without-dummy-data%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

active

oldest

votes

draft saved

draft discarded

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.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Gfrktyl