Excel: Trouble graphing 3 sets of data properly
I've got this table:
Name Tech NotTech TechToNotTechRatio
Abc 115 121 0.95
Bca 127 186 0.68
Cab 135 160 0.84
Cba 149 196 0.76
Bac 142 185 0.77
Acb 148 221 0.67
Aaa 186 200 0.93
Bbb 227 249 0.91
Ccc 241 360 0.67
Abb 289 457 0.63
And this list continues up to 33 rows. I want to design a chart in which Tech and NotTech columns will be displayed as vertical bars (or cylinders or pyramids). The last column (That is their ratio) should be a line or something over them (Just to give my customer a visualized sense of the ratio alongside plain numbers of technicians and non-technicians). This is what I get when I try it normally by selecting these data sets:
My excel graph that the third set of data is not shown properly:
As you can see the third set cannot be seen because of its very small values comparing to other columns. How can I correct it?
microsoft-excel microsoft-excel-2010 charts
edited Dec 29 '18 at 15:56
cybernetic.nomad
1,493112
asked Dec 29 '18 at 9:43
VynylynVynylyn
85
add a comment |
I've got this table:
Name Tech NotTech TechToNotTechRatio
Abc 115 121 0.95
Bca 127 186 0.68
Cab 135 160 0.84
Cba 149 196 0.76
Bac 142 185 0.77
Acb 148 221 0.67
Aaa 186 200 0.93
Bbb 227 249 0.91
Ccc 241 360 0.67
Abb 289 457 0.63
And this list continues up to 33 rows. I want to design a chart in which Tech and NotTech columns will be displayed as vertical bars (or cylinders or pyramids). The last column (That is their ratio) should be a line or something over them (Just to give my customer a visualized sense of the ratio alongside plain numbers of technicians and non-technicians). This is what I get when I try it normally by selecting these data sets:
My excel graph that the third set of data is not shown properly:
As you can see the third set cannot be seen because of its very small values comparing to other columns. How can I correct it?
microsoft-excel microsoft-excel-2010 charts
edited Dec 29 '18 at 15:56
cybernetic.nomad
1,493112
asked Dec 29 '18 at 9:43
VynylynVynylyn
85
1
The vertical bars next to each other are already a much more intuitive indicator of the ratio than any line you could add. The line will detract, unless the purpose is to put everything on the same scale relative to 100%. Too much detail on a chart is visually confusing. You are usually better off picking either the values or the ratio, and plotting one or the other. But if you need both, use a second scale for the ratio. You would have the scale for the bars on the left axis, and the scale for the ratio on the right axis.
– fixer1234
Dec 29 '18 at 10:08
add a comment |
I've got this table:
Name Tech NotTech TechToNotTechRatio
Abc 115 121 0.95
Bca 127 186 0.68
Cab 135 160 0.84
Cba 149 196 0.76
Bac 142 185 0.77
Acb 148 221 0.67
Aaa 186 200 0.93
Bbb 227 249 0.91
Ccc 241 360 0.67
Abb 289 457 0.63
And this list continues up to 33 rows. I want to design a chart in which Tech and NotTech columns will be displayed as vertical bars (or cylinders or pyramids). The last column (That is their ratio) should be a line or something over them (Just to give my customer a visualized sense of the ratio alongside plain numbers of technicians and non-technicians). This is what I get when I try it normally by selecting these data sets:
My excel graph that the third set of data is not shown properly:
As you can see the third set cannot be seen because of its very small values comparing to other columns. How can I correct it?
microsoft-excel microsoft-excel-2010 charts
edited Dec 29 '18 at 15:56
cybernetic.nomad
1,493112
asked Dec 29 '18 at 9:43
VynylynVynylyn
85
I've got this table:
Name Tech NotTech TechToNotTechRatio
Abc 115 121 0.95
Bca 127 186 0.68
Cab 135 160 0.84
Cba 149 196 0.76
Bac 142 185 0.77
Acb 148 221 0.67
Aaa 186 200 0.93
Bbb 227 249 0.91
Ccc 241 360 0.67
Abb 289 457 0.63
And this list continues up to 33 rows. I want to design a chart in which Tech and NotTech columns will be displayed as vertical bars (or cylinders or pyramids). The last column (That is their ratio) should be a line or something over them (Just to give my customer a visualized sense of the ratio alongside plain numbers of technicians and non-technicians). This is what I get when I try it normally by selecting these data sets:
My excel graph that the third set of data is not shown properly:
As you can see the third set cannot be seen because of its very small values comparing to other columns. How can I correct it?
microsoft-excel microsoft-excel-2010 charts
microsoft-excel microsoft-excel-2010 charts
edited Dec 29 '18 at 15:56
cybernetic.nomad
1,493112
asked Dec 29 '18 at 9:43
VynylynVynylyn
85
edited Dec 29 '18 at 15:56
cybernetic.nomad
1,493112
asked Dec 29 '18 at 9:43
VynylynVynylyn
85
edited Dec 29 '18 at 15:56
cybernetic.nomad
1,493112
edited Dec 29 '18 at 15:56
cybernetic.nomad
1,493112
edited Dec 29 '18 at 15:56
cybernetic.nomad
1,493112
1,493112
asked Dec 29 '18 at 9:43
VynylynVynylyn
85
asked Dec 29 '18 at 9:43
VynylynVynylyn
85
asked Dec 29 '18 at 9:43
VynylynVynylyn
85
85
1
The vertical bars next to each other are already a much more intuitive indicator of the ratio than any line you could add. The line will detract, unless the purpose is to put everything on the same scale relative to 100%. Too much detail on a chart is visually confusing. You are usually better off picking either the values or the ratio, and plotting one or the other. But if you need both, use a second scale for the ratio. You would have the scale for the bars on the left axis, and the scale for the ratio on the right axis.
– fixer1234
Dec 29 '18 at 10:08
add a comment |
1
The vertical bars next to each other are already a much more intuitive indicator of the ratio than any line you could add. The line will detract, unless the purpose is to put everything on the same scale relative to 100%. Too much detail on a chart is visually confusing. You are usually better off picking either the values or the ratio, and plotting one or the other. But if you need both, use a second scale for the ratio. You would have the scale for the bars on the left axis, and the scale for the ratio on the right axis.
– fixer1234
Dec 29 '18 at 10:08
1
1
The vertical bars next to each other are already a much more intuitive indicator of the ratio than any line you could add. The line will detract, unless the purpose is to put everything on the same scale relative to 100%. Too much detail on a chart is visually confusing. You are usually better off picking either the values or the ratio, and plotting one or the other. But if you need both, use a second scale for the ratio. You would have the scale for the bars on the left axis, and the scale for the ratio on the right axis.
– fixer1234
Dec 29 '18 at 10:08
The vertical bars next to each other are already a much more intuitive indicator of the ratio than any line you could add. The line will detract, unless the purpose is to put everything on the same scale relative to 100%. Too much detail on a chart is visually confusing. You are usually better off picking either the values or the ratio, and plotting one or the other. But if you need both, use a second scale for the ratio. You would have the scale for the bars on the left axis, and the scale for the ratio on the right axis.
– fixer1234
Dec 29 '18 at 10:08
add a comment |
1 Answer
1
active
oldest
votes
You can choose a Combo chart, use Clustered Column for "Tech" and "NotTech", Line for "TechToNotTechRatio" and check off Secondary Axis. You should see what you describe and see that @fixer1234 is right: the line is distracting at best.
answered Dec 31 '18 at 16:54
cybernetic.nomadcybernetic.nomad
1,493112
Oh thanks! The one you created is good.
– Vynylyn
Jan 5 at 8:19
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%2f1388698%2fexcel-trouble-graphing-3-sets-of-data-properly%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
You can choose a Combo chart, use Clustered Column for "Tech" and "NotTech", Line for "TechToNotTechRatio" and check off Secondary Axis. You should see what you describe and see that @fixer1234 is right: the line is distracting at best.
answered Dec 31 '18 at 16:54
cybernetic.nomadcybernetic.nomad
1,493112
Oh thanks! The one you created is good.
– Vynylyn
Jan 5 at 8:19
add a comment |
You can choose a Combo chart, use Clustered Column for "Tech" and "NotTech", Line for "TechToNotTechRatio" and check off Secondary Axis. You should see what you describe and see that @fixer1234 is right: the line is distracting at best.
answered Dec 31 '18 at 16:54
cybernetic.nomadcybernetic.nomad
1,493112
Oh thanks! The one you created is good.
– Vynylyn
Jan 5 at 8:19
add a comment |
You can choose a Combo chart, use Clustered Column for "Tech" and "NotTech", Line for "TechToNotTechRatio" and check off Secondary Axis. You should see what you describe and see that @fixer1234 is right: the line is distracting at best.
answered Dec 31 '18 at 16:54
cybernetic.nomadcybernetic.nomad
1,493112
You can choose a Combo chart, use Clustered Column for "Tech" and "NotTech", Line for "TechToNotTechRatio" and check off Secondary Axis. You should see what you describe and see that @fixer1234 is right: the line is distracting at best.
answered Dec 31 '18 at 16:54
cybernetic.nomadcybernetic.nomad
1,493112
answered Dec 31 '18 at 16:54
cybernetic.nomadcybernetic.nomad
1,493112
answered Dec 31 '18 at 16:54
cybernetic.nomadcybernetic.nomad
1,493112
answered Dec 31 '18 at 16:54
cybernetic.nomadcybernetic.nomad
1,493112
1,493112
Oh thanks! The one you created is good.
– Vynylyn
Jan 5 at 8:19
add a comment |
Oh thanks! The one you created is good.
– Vynylyn
Jan 5 at 8:19
Oh thanks! The one you created is good.
– Vynylyn
Jan 5 at 8:19
Oh thanks! The one you created is good.
– Vynylyn
Jan 5 at 8:19
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%2f1388698%2fexcel-trouble-graphing-3-sets-of-data-properly%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
1
The vertical bars next to each other are already a much more intuitive indicator of the ratio than any line you could add. The line will detract, unless the purpose is to put everything on the same scale relative to 100%. Too much detail on a chart is visually confusing. You are usually better off picking either the values or the ratio, and plotting one or the other. But if you need both, use a second scale for the ratio. You would have the scale for the bars on the left axis, and the scale for the ratio on the right axis.
– fixer1234
Dec 29 '18 at 10:08