Hiding a column from a pivot table without removing it from the chart
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I have a pivot table with two columns: number of users who visited a website (impressions) and number of users who registered on the site (regs). The rows are for dates.
I want to visualize the percentage of users who registered after visiting the site. Thus, I have the number of users for each cell as a value field, displaying it as percentage of impressions. Generating a pivot chart from the table, impressions and regs are plotted over date as a percentage of impressions. This means there is one line at 100% for impressions (always 100% of itself) and the graph for registrations below that.
I'd like to remove the line for impressions, but when I set a filter to do so, registrations vanish as well, since the column for impressions is filtered from the pivot chart as well, turning the value field invalid.
How can I just show registrations as a percentage of impressions in the chart?
microsoft-excel charts pivot-table
asked Oct 31 '13 at 9:37
SimonSimon
113
add a comment |
I have a pivot table with two columns: number of users who visited a website (impressions) and number of users who registered on the site (regs). The rows are for dates.
I want to visualize the percentage of users who registered after visiting the site. Thus, I have the number of users for each cell as a value field, displaying it as percentage of impressions. Generating a pivot chart from the table, impressions and regs are plotted over date as a percentage of impressions. This means there is one line at 100% for impressions (always 100% of itself) and the graph for registrations below that.
I'd like to remove the line for impressions, but when I set a filter to do so, registrations vanish as well, since the column for impressions is filtered from the pivot chart as well, turning the value field invalid.
How can I just show registrations as a percentage of impressions in the chart?
microsoft-excel charts pivot-table
asked Oct 31 '13 at 9:37
SimonSimon
113
add a comment |
I have a pivot table with two columns: number of users who visited a website (impressions) and number of users who registered on the site (regs). The rows are for dates.
I want to visualize the percentage of users who registered after visiting the site. Thus, I have the number of users for each cell as a value field, displaying it as percentage of impressions. Generating a pivot chart from the table, impressions and regs are plotted over date as a percentage of impressions. This means there is one line at 100% for impressions (always 100% of itself) and the graph for registrations below that.
I'd like to remove the line for impressions, but when I set a filter to do so, registrations vanish as well, since the column for impressions is filtered from the pivot chart as well, turning the value field invalid.
How can I just show registrations as a percentage of impressions in the chart?
microsoft-excel charts pivot-table
asked Oct 31 '13 at 9:37
SimonSimon
113
I have a pivot table with two columns: number of users who visited a website (impressions) and number of users who registered on the site (regs). The rows are for dates.
I want to visualize the percentage of users who registered after visiting the site. Thus, I have the number of users for each cell as a value field, displaying it as percentage of impressions. Generating a pivot chart from the table, impressions and regs are plotted over date as a percentage of impressions. This means there is one line at 100% for impressions (always 100% of itself) and the graph for registrations below that.
I'd like to remove the line for impressions, but when I set a filter to do so, registrations vanish as well, since the column for impressions is filtered from the pivot chart as well, turning the value field invalid.
How can I just show registrations as a percentage of impressions in the chart?
microsoft-excel charts pivot-table
microsoft-excel charts pivot-table
asked Oct 31 '13 at 9:37
SimonSimon
113
asked Oct 31 '13 at 9:37
SimonSimon
113
asked Oct 31 '13 at 9:37
SimonSimon
113
asked Oct 31 '13 at 9:37
SimonSimon
113
asked Oct 31 '13 at 9:37
SimonSimon
113
113
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
I think your title has what you want backwards. Your description sounds like you want to hide data from the chart but not from the table.
You could:
Make a regular chart from the pivot table data, which includes only some of the pivot data. Updating the chart will fail if the pivot table changes size.
Hide the unwanted series in the pivot chart (no markers and lines, or no borders and fills).
Exclude the unwanted data from the pivot table.
Make a second pivot table with just the data you want to show in the chart.
answered Oct 18 '14 at 21:20
Jon PeltierJon Peltier
2,9621420
add a comment |
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%2f667748%2fhiding-a-column-from-a-pivot-table-without-removing-it-from-the-chart%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I think your title has what you want backwards. Your description sounds like you want to hide data from the chart but not from the table.
You could:
Make a regular chart from the pivot table data, which includes only some of the pivot data. Updating the chart will fail if the pivot table changes size.
Hide the unwanted series in the pivot chart (no markers and lines, or no borders and fills).
Exclude the unwanted data from the pivot table.
Make a second pivot table with just the data you want to show in the chart.
answered Oct 18 '14 at 21:20
Jon PeltierJon Peltier
2,9621420
add a comment |
I think your title has what you want backwards. Your description sounds like you want to hide data from the chart but not from the table.
You could:
Make a regular chart from the pivot table data, which includes only some of the pivot data. Updating the chart will fail if the pivot table changes size.
Hide the unwanted series in the pivot chart (no markers and lines, or no borders and fills).
Exclude the unwanted data from the pivot table.
Make a second pivot table with just the data you want to show in the chart.
answered Oct 18 '14 at 21:20
Jon PeltierJon Peltier
2,9621420
add a comment |
I think your title has what you want backwards. Your description sounds like you want to hide data from the chart but not from the table.
You could:
Make a regular chart from the pivot table data, which includes only some of the pivot data. Updating the chart will fail if the pivot table changes size.
Hide the unwanted series in the pivot chart (no markers and lines, or no borders and fills).
Exclude the unwanted data from the pivot table.
Make a second pivot table with just the data you want to show in the chart.
answered Oct 18 '14 at 21:20
Jon PeltierJon Peltier
2,9621420
I think your title has what you want backwards. Your description sounds like you want to hide data from the chart but not from the table.
You could:
Make a regular chart from the pivot table data, which includes only some of the pivot data. Updating the chart will fail if the pivot table changes size.
Hide the unwanted series in the pivot chart (no markers and lines, or no borders and fills).
Exclude the unwanted data from the pivot table.
Make a second pivot table with just the data you want to show in the chart.
answered Oct 18 '14 at 21:20
Jon PeltierJon Peltier
2,9621420
answered Oct 18 '14 at 21:20
Jon PeltierJon Peltier
2,9621420
answered Oct 18 '14 at 21:20
Jon PeltierJon Peltier
2,9621420
answered Oct 18 '14 at 21:20
Jon PeltierJon Peltier
2,9621420
2,9621420
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.
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%2f667748%2fhiding-a-column-from-a-pivot-table-without-removing-it-from-the-chart%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
