Grouping Excel graph categories
Is there a way to group categories in an Excel graph or provide color distinctions? I have searched around and while their are ways to group categories in 2D graphs, I have not found an example the uses a z-axis. In the example below, the desired group separation is shown in the red, orange, and turquoise polygon's. If there is not a way to separate the groups to provide distinction, is there a way to change the bar colors to provide category group separate designations?
Conclusion:
If you only have a single series of data, you may "Vary colors by point" per http://office.microsoft.com/en-us/excel-help/vary-the-colors-of-same-series-data-markers-in-a-chart-HP010007429.aspx#BM2. This does not work if you have a graph with more than one series whether 3D or not.
The option I have found is to double-click each data-point (in this case bar) and manually change the color.
microsoft-excel
asked Dec 27 '13 at 13:50
AstronAstron
16718
add a comment |
Is there a way to group categories in an Excel graph or provide color distinctions? I have searched around and while their are ways to group categories in 2D graphs, I have not found an example the uses a z-axis. In the example below, the desired group separation is shown in the red, orange, and turquoise polygon's. If there is not a way to separate the groups to provide distinction, is there a way to change the bar colors to provide category group separate designations?
Conclusion:
If you only have a single series of data, you may "Vary colors by point" per http://office.microsoft.com/en-us/excel-help/vary-the-colors-of-same-series-data-markers-in-a-chart-HP010007429.aspx#BM2. This does not work if you have a graph with more than one series whether 3D or not.
The option I have found is to double-click each data-point (in this case bar) and manually change the color.
microsoft-excel
asked Dec 27 '13 at 13:50
AstronAstron
16718
add a comment |
Is there a way to group categories in an Excel graph or provide color distinctions? I have searched around and while their are ways to group categories in 2D graphs, I have not found an example the uses a z-axis. In the example below, the desired group separation is shown in the red, orange, and turquoise polygon's. If there is not a way to separate the groups to provide distinction, is there a way to change the bar colors to provide category group separate designations?
Conclusion:
If you only have a single series of data, you may "Vary colors by point" per http://office.microsoft.com/en-us/excel-help/vary-the-colors-of-same-series-data-markers-in-a-chart-HP010007429.aspx#BM2. This does not work if you have a graph with more than one series whether 3D or not.
The option I have found is to double-click each data-point (in this case bar) and manually change the color.
microsoft-excel
asked Dec 27 '13 at 13:50
AstronAstron
16718
Is there a way to group categories in an Excel graph or provide color distinctions? I have searched around and while their are ways to group categories in 2D graphs, I have not found an example the uses a z-axis. In the example below, the desired group separation is shown in the red, orange, and turquoise polygon's. If there is not a way to separate the groups to provide distinction, is there a way to change the bar colors to provide category group separate designations?
Conclusion:
If you only have a single series of data, you may "Vary colors by point" per http://office.microsoft.com/en-us/excel-help/vary-the-colors-of-same-series-data-markers-in-a-chart-HP010007429.aspx#BM2. This does not work if you have a graph with more than one series whether 3D or not.
The option I have found is to double-click each data-point (in this case bar) and manually change the color.
microsoft-excel
microsoft-excel
asked Dec 27 '13 at 13:50
AstronAstron
16718
asked Dec 27 '13 at 13:50
AstronAstron
16718
edited Dec 27 '13 at 19:42
Astron
asked Dec 27 '13 at 13:50
AstronAstron
16718
asked Dec 27 '13 at 13:50
AstronAstron
16718
asked Dec 27 '13 at 13:50
AstronAstron
16718
16718
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
Short answer is to create 3 different series of data.
Sample (not yours but enough to hopefully get you started)
column A B C
Data 1 1
Data 2 2
Data 3 3
Data 4 2
Data 5 3
Data 6 4
Data 7 3
Data 8 4
Data 9 5
Now you can color the series' different colors, and not have to color each individual point.
answered Dec 27 '13 at 21:02
guitarthrowerguitarthrower
8682715
add a comment |
It's probably best not to overcomplicate things with too many colors, though shades of colors might work.
However, the first thing to do is to make a 2D chart. The 3D chart is useless for comparing the sizes of bars, and while you have data labels on all the bars, it's not as useful as a table, because a table lines up the values in an easier to read arrangement.
By inserting blank rows between blocks of data, you can effectively cluster groups of columns together in the chart.
answered Jul 17 '15 at 15:13
Jon PeltierJon Peltier
2,8521220
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%2f693743%2fgrouping-excel-graph-categories%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Short answer is to create 3 different series of data.
Sample (not yours but enough to hopefully get you started)
column A B C
Data 1 1
Data 2 2
Data 3 3
Data 4 2
Data 5 3
Data 6 4
Data 7 3
Data 8 4
Data 9 5
Now you can color the series' different colors, and not have to color each individual point.
answered Dec 27 '13 at 21:02
guitarthrowerguitarthrower
8682715
add a comment |
Short answer is to create 3 different series of data.
Sample (not yours but enough to hopefully get you started)
column A B C
Data 1 1
Data 2 2
Data 3 3
Data 4 2
Data 5 3
Data 6 4
Data 7 3
Data 8 4
Data 9 5
Now you can color the series' different colors, and not have to color each individual point.
answered Dec 27 '13 at 21:02
guitarthrowerguitarthrower
8682715
add a comment |
Short answer is to create 3 different series of data.
Sample (not yours but enough to hopefully get you started)
column A B C
Data 1 1
Data 2 2
Data 3 3
Data 4 2
Data 5 3
Data 6 4
Data 7 3
Data 8 4
Data 9 5
Now you can color the series' different colors, and not have to color each individual point.
answered Dec 27 '13 at 21:02
guitarthrowerguitarthrower
8682715
Short answer is to create 3 different series of data.
Sample (not yours but enough to hopefully get you started)
column A B C
Data 1 1
Data 2 2
Data 3 3
Data 4 2
Data 5 3
Data 6 4
Data 7 3
Data 8 4
Data 9 5
Now you can color the series' different colors, and not have to color each individual point.
answered Dec 27 '13 at 21:02
guitarthrowerguitarthrower
8682715
answered Dec 27 '13 at 21:02
guitarthrowerguitarthrower
8682715
answered Dec 27 '13 at 21:02
guitarthrowerguitarthrower
8682715
answered Dec 27 '13 at 21:02
guitarthrowerguitarthrower
8682715
8682715
add a comment |
add a comment |
It's probably best not to overcomplicate things with too many colors, though shades of colors might work.
However, the first thing to do is to make a 2D chart. The 3D chart is useless for comparing the sizes of bars, and while you have data labels on all the bars, it's not as useful as a table, because a table lines up the values in an easier to read arrangement.
By inserting blank rows between blocks of data, you can effectively cluster groups of columns together in the chart.
answered Jul 17 '15 at 15:13
Jon PeltierJon Peltier
2,8521220
add a comment |
It's probably best not to overcomplicate things with too many colors, though shades of colors might work.
However, the first thing to do is to make a 2D chart. The 3D chart is useless for comparing the sizes of bars, and while you have data labels on all the bars, it's not as useful as a table, because a table lines up the values in an easier to read arrangement.
By inserting blank rows between blocks of data, you can effectively cluster groups of columns together in the chart.
answered Jul 17 '15 at 15:13
Jon PeltierJon Peltier
2,8521220
add a comment |
It's probably best not to overcomplicate things with too many colors, though shades of colors might work.
However, the first thing to do is to make a 2D chart. The 3D chart is useless for comparing the sizes of bars, and while you have data labels on all the bars, it's not as useful as a table, because a table lines up the values in an easier to read arrangement.
By inserting blank rows between blocks of data, you can effectively cluster groups of columns together in the chart.
answered Jul 17 '15 at 15:13
Jon PeltierJon Peltier
2,8521220
It's probably best not to overcomplicate things with too many colors, though shades of colors might work.
However, the first thing to do is to make a 2D chart. The 3D chart is useless for comparing the sizes of bars, and while you have data labels on all the bars, it's not as useful as a table, because a table lines up the values in an easier to read arrangement.
By inserting blank rows between blocks of data, you can effectively cluster groups of columns together in the chart.
answered Jul 17 '15 at 15:13
Jon PeltierJon Peltier
2,8521220
answered Jul 17 '15 at 15:13
Jon PeltierJon Peltier
2,8521220
answered Jul 17 '15 at 15:13
Jon PeltierJon Peltier
2,8521220
answered Jul 17 '15 at 15:13
Jon PeltierJon Peltier
2,8521220
2,8521220
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%2f693743%2fgrouping-excel-graph-categories%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
