Combining categories in charts
up vote
1
down vote
favorite
How do I combine "Chicken", "Moose" and "Pork" into one "Meat"-name, and the remainders into just "Seafood"?
I would also want to show how much of the "meat" and "seafood" are "fresh" and "frozen"?
microsoft-excel charts combine pivot-chart
add a comment |
up vote
1
down vote
favorite
How do I combine "Chicken", "Moose" and "Pork" into one "Meat"-name, and the remainders into just "Seafood"?
I would also want to show how much of the "meat" and "seafood" are "fresh" and "frozen"?
microsoft-excel charts combine pivot-chart
Be advised that you are treading on thin ice, terminology-wise. Some people believe that fish is meat. Other people believe that poultry (e.g., chicken) is not meat. Some people feel as strongly about this as they do about religious issues.
– Scott
Nov 24 at 18:56
@Blackwood: Thanks for embedding the image. But, when you do that, please make the image link to itself, as I have done in my edit.
– Scott
Nov 24 at 19:00
Thanks @Scott. Can you explain the difference, or point me to an explanation?
– Blackwood
Nov 24 at 19:11
The difference is that, the way I did it, a reader can click on the displayed image (which is typically scaled down to 640 pixels wide to fit in the Super User text area) and go directly to the image on imgur.com (which, in this case, is over 1000 pixels wide). Or, more usefully, Ctrl+click to open the image in a new tab. (Some browsers have features that let you do this, but not all.) The idea is discussed here, although it might not be as clear and up to date as it could be.
– Scott
Nov 24 at 19:28
add a comment |
up vote
1
down vote
favorite
up vote
1
down vote
favorite
How do I combine "Chicken", "Moose" and "Pork" into one "Meat"-name, and the remainders into just "Seafood"?
I would also want to show how much of the "meat" and "seafood" are "fresh" and "frozen"?
microsoft-excel charts combine pivot-chart
How do I combine "Chicken", "Moose" and "Pork" into one "Meat"-name, and the remainders into just "Seafood"?
I would also want to show how much of the "meat" and "seafood" are "fresh" and "frozen"?
microsoft-excel charts combine pivot-chart
microsoft-excel charts combine pivot-chart
edited Nov 24 at 18:04
Scott
15.5k113789
15.5k113789
asked Nov 24 at 17:39
pilti
61
61
Be advised that you are treading on thin ice, terminology-wise. Some people believe that fish is meat. Other people believe that poultry (e.g., chicken) is not meat. Some people feel as strongly about this as they do about religious issues.
– Scott
Nov 24 at 18:56
@Blackwood: Thanks for embedding the image. But, when you do that, please make the image link to itself, as I have done in my edit.
– Scott
Nov 24 at 19:00
Thanks @Scott. Can you explain the difference, or point me to an explanation?
– Blackwood
Nov 24 at 19:11
The difference is that, the way I did it, a reader can click on the displayed image (which is typically scaled down to 640 pixels wide to fit in the Super User text area) and go directly to the image on imgur.com (which, in this case, is over 1000 pixels wide). Or, more usefully, Ctrl+click to open the image in a new tab. (Some browsers have features that let you do this, but not all.) The idea is discussed here, although it might not be as clear and up to date as it could be.
– Scott
Nov 24 at 19:28
add a comment |
Be advised that you are treading on thin ice, terminology-wise. Some people believe that fish is meat. Other people believe that poultry (e.g., chicken) is not meat. Some people feel as strongly about this as they do about religious issues.
– Scott
Nov 24 at 18:56
@Blackwood: Thanks for embedding the image. But, when you do that, please make the image link to itself, as I have done in my edit.
– Scott
Nov 24 at 19:00
Thanks @Scott. Can you explain the difference, or point me to an explanation?
– Blackwood
Nov 24 at 19:11
The difference is that, the way I did it, a reader can click on the displayed image (which is typically scaled down to 640 pixels wide to fit in the Super User text area) and go directly to the image on imgur.com (which, in this case, is over 1000 pixels wide). Or, more usefully, Ctrl+click to open the image in a new tab. (Some browsers have features that let you do this, but not all.) The idea is discussed here, although it might not be as clear and up to date as it could be.
– Scott
Nov 24 at 19:28
Be advised that you are treading on thin ice, terminology-wise. Some people believe that fish is meat. Other people believe that poultry (e.g., chicken) is not meat. Some people feel as strongly about this as they do about religious issues.
– Scott
Nov 24 at 18:56
Be advised that you are treading on thin ice, terminology-wise. Some people believe that fish is meat. Other people believe that poultry (e.g., chicken) is not meat. Some people feel as strongly about this as they do about religious issues.
– Scott
Nov 24 at 18:56
@Blackwood: Thanks for embedding the image. But, when you do that, please make the image link to itself, as I have done in my edit.
– Scott
Nov 24 at 19:00
@Blackwood: Thanks for embedding the image. But, when you do that, please make the image link to itself, as I have done in my edit.
– Scott
Nov 24 at 19:00
Thanks @Scott. Can you explain the difference, or point me to an explanation?
– Blackwood
Nov 24 at 19:11
Thanks @Scott. Can you explain the difference, or point me to an explanation?
– Blackwood
Nov 24 at 19:11
The difference is that, the way I did it, a reader can click on the displayed image (which is typically scaled down to 640 pixels wide to fit in the Super User text area) and go directly to the image on imgur.com (which, in this case, is over 1000 pixels wide). Or, more usefully, Ctrl+click to open the image in a new tab. (Some browsers have features that let you do this, but not all.) The idea is discussed here, although it might not be as clear and up to date as it could be.
– Scott
Nov 24 at 19:28
The difference is that, the way I did it, a reader can click on the displayed image (which is typically scaled down to 640 pixels wide to fit in the Super User text area) and go directly to the image on imgur.com (which, in this case, is over 1000 pixels wide). Or, more usefully, Ctrl+click to open the image in a new tab. (Some browsers have features that let you do this, but not all.) The idea is discussed here, although it might not be as clear and up to date as it could be.
– Scott
Nov 24 at 19:28
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
To get a chart showing “meat” vs. “seafood”,
you will probably need to have a separate range
that shows just those two categories.
You won't need to maintain the data separately;
just use SUM
or SUMIF
formulas.
You might also be able to do something
with a PivotTable and/or a PivotChart.
I'm not sufficiently familiar with those to give an answer;
probably somebody else will.
Once you create your “meat” vs. “seafood” chart,
there are multiple ways of displaying multiple data series
(e.g., “fresh” vs. “frozen”).
I suggest a “Stacked Column” chart.
Thanks, I'll give it a try
– pilti
Nov 24 at 19:19
Well? Any results?
– Scott
Nov 26 at 23:45
I was able to sort it out like you said. However, I guess there are other, perhaps easier ways of doing it. Anyway, thanks for helping out!
– pilti
Nov 28 at 9:31
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
To get a chart showing “meat” vs. “seafood”,
you will probably need to have a separate range
that shows just those two categories.
You won't need to maintain the data separately;
just use SUM
or SUMIF
formulas.
You might also be able to do something
with a PivotTable and/or a PivotChart.
I'm not sufficiently familiar with those to give an answer;
probably somebody else will.
Once you create your “meat” vs. “seafood” chart,
there are multiple ways of displaying multiple data series
(e.g., “fresh” vs. “frozen”).
I suggest a “Stacked Column” chart.
Thanks, I'll give it a try
– pilti
Nov 24 at 19:19
Well? Any results?
– Scott
Nov 26 at 23:45
I was able to sort it out like you said. However, I guess there are other, perhaps easier ways of doing it. Anyway, thanks for helping out!
– pilti
Nov 28 at 9:31
add a comment |
up vote
0
down vote
To get a chart showing “meat” vs. “seafood”,
you will probably need to have a separate range
that shows just those two categories.
You won't need to maintain the data separately;
just use SUM
or SUMIF
formulas.
You might also be able to do something
with a PivotTable and/or a PivotChart.
I'm not sufficiently familiar with those to give an answer;
probably somebody else will.
Once you create your “meat” vs. “seafood” chart,
there are multiple ways of displaying multiple data series
(e.g., “fresh” vs. “frozen”).
I suggest a “Stacked Column” chart.
Thanks, I'll give it a try
– pilti
Nov 24 at 19:19
Well? Any results?
– Scott
Nov 26 at 23:45
I was able to sort it out like you said. However, I guess there are other, perhaps easier ways of doing it. Anyway, thanks for helping out!
– pilti
Nov 28 at 9:31
add a comment |
up vote
0
down vote
up vote
0
down vote
To get a chart showing “meat” vs. “seafood”,
you will probably need to have a separate range
that shows just those two categories.
You won't need to maintain the data separately;
just use SUM
or SUMIF
formulas.
You might also be able to do something
with a PivotTable and/or a PivotChart.
I'm not sufficiently familiar with those to give an answer;
probably somebody else will.
Once you create your “meat” vs. “seafood” chart,
there are multiple ways of displaying multiple data series
(e.g., “fresh” vs. “frozen”).
I suggest a “Stacked Column” chart.
To get a chart showing “meat” vs. “seafood”,
you will probably need to have a separate range
that shows just those two categories.
You won't need to maintain the data separately;
just use SUM
or SUMIF
formulas.
You might also be able to do something
with a PivotTable and/or a PivotChart.
I'm not sufficiently familiar with those to give an answer;
probably somebody else will.
Once you create your “meat” vs. “seafood” chart,
there are multiple ways of displaying multiple data series
(e.g., “fresh” vs. “frozen”).
I suggest a “Stacked Column” chart.
answered Nov 24 at 18:49
Scott
15.5k113789
15.5k113789
Thanks, I'll give it a try
– pilti
Nov 24 at 19:19
Well? Any results?
– Scott
Nov 26 at 23:45
I was able to sort it out like you said. However, I guess there are other, perhaps easier ways of doing it. Anyway, thanks for helping out!
– pilti
Nov 28 at 9:31
add a comment |
Thanks, I'll give it a try
– pilti
Nov 24 at 19:19
Well? Any results?
– Scott
Nov 26 at 23:45
I was able to sort it out like you said. However, I guess there are other, perhaps easier ways of doing it. Anyway, thanks for helping out!
– pilti
Nov 28 at 9:31
Thanks, I'll give it a try
– pilti
Nov 24 at 19:19
Thanks, I'll give it a try
– pilti
Nov 24 at 19:19
Well? Any results?
– Scott
Nov 26 at 23:45
Well? Any results?
– Scott
Nov 26 at 23:45
I was able to sort it out like you said. However, I guess there are other, perhaps easier ways of doing it. Anyway, thanks for helping out!
– pilti
Nov 28 at 9:31
I was able to sort it out like you said. However, I guess there are other, perhaps easier ways of doing it. Anyway, thanks for helping out!
– pilti
Nov 28 at 9:31
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%2f1378067%2fcombining-categories-in-charts%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
Be advised that you are treading on thin ice, terminology-wise. Some people believe that fish is meat. Other people believe that poultry (e.g., chicken) is not meat. Some people feel as strongly about this as they do about religious issues.
– Scott
Nov 24 at 18:56
@Blackwood: Thanks for embedding the image. But, when you do that, please make the image link to itself, as I have done in my edit.
– Scott
Nov 24 at 19:00
Thanks @Scott. Can you explain the difference, or point me to an explanation?
– Blackwood
Nov 24 at 19:11
The difference is that, the way I did it, a reader can click on the displayed image (which is typically scaled down to 640 pixels wide to fit in the Super User text area) and go directly to the image on imgur.com (which, in this case, is over 1000 pixels wide). Or, more usefully, Ctrl+click to open the image in a new tab. (Some browsers have features that let you do this, but not all.) The idea is discussed here, although it might not be as clear and up to date as it could be.
– Scott
Nov 24 at 19:28