Chart on Excel with grouped data
In the image bellow, I have some data on columns Item, Type and Value. I would like to know how can I create a pie chart aggregated by the column Type. I mean, I would like just one slice for each type Office, Commerce, Store and Industry and the value would be the sum of each type. Is there an easy way to do this?
microsoft-excel microsoft-office charts
asked Dec 26 '18 at 12:27
Felipe OrianiFelipe Oriani
12516
add a comment |
In the image bellow, I have some data on columns Item, Type and Value. I would like to know how can I create a pie chart aggregated by the column Type. I mean, I would like just one slice for each type Office, Commerce, Store and Industry and the value would be the sum of each type. Is there an easy way to do this?
microsoft-excel microsoft-office charts
asked Dec 26 '18 at 12:27
Felipe OrianiFelipe Oriani
12516
A pivot chart may be useful.
– Mark Fitzgerald
Dec 26 '18 at 13:34
add a comment |
In the image bellow, I have some data on columns Item, Type and Value. I would like to know how can I create a pie chart aggregated by the column Type. I mean, I would like just one slice for each type Office, Commerce, Store and Industry and the value would be the sum of each type. Is there an easy way to do this?
microsoft-excel microsoft-office charts
asked Dec 26 '18 at 12:27
Felipe OrianiFelipe Oriani
12516
In the image bellow, I have some data on columns Item, Type and Value. I would like to know how can I create a pie chart aggregated by the column Type. I mean, I would like just one slice for each type Office, Commerce, Store and Industry and the value would be the sum of each type. Is there an easy way to do this?
microsoft-excel microsoft-office charts
microsoft-excel microsoft-office charts
asked Dec 26 '18 at 12:27
Felipe OrianiFelipe Oriani
12516
asked Dec 26 '18 at 12:27
Felipe OrianiFelipe Oriani
12516
asked Dec 26 '18 at 12:27
Felipe OrianiFelipe Oriani
12516
asked Dec 26 '18 at 12:27
Felipe OrianiFelipe Oriani
12516
asked Dec 26 '18 at 12:27
Felipe OrianiFelipe Oriani
12516
12516
A pivot chart may be useful.
– Mark Fitzgerald
Dec 26 '18 at 13:34
add a comment |
A pivot chart may be useful.
– Mark Fitzgerald
Dec 26 '18 at 13:34
A pivot chart may be useful.
– Mark Fitzgerald
Dec 26 '18 at 13:34
A pivot chart may be useful.
– Mark Fitzgerald
Dec 26 '18 at 13:34
add a comment |
1 Answer
1
active
oldest
votes
A pivot chart will allow you to display Type totals without showing two items of the same Type.
On the Ribbon Insert tab, click on PivotChart.
If a cell within your data is active then your data should be selected automatically. Specify where you want your chart and click OK. A blank chart will appear.
In the PivotChart Field List, drag Type to the Axis box and Value to the Values box. By default you will see a bar chart. Right-click on the Chart Area and select Change Chart Type... and select Pie.
After manipulating chart components such as Legend, Title, Chart Area,, etc. you should be able to get to something like:
answered Dec 27 '18 at 1:59
Mark FitzgeraldMark Fitzgerald
3681211
Thank you Mark, I will try it out.
– Felipe Oriani
Dec 28 '18 at 11:32
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%2f1387803%2fchart-on-excel-with-grouped-data%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
A pivot chart will allow you to display Type totals without showing two items of the same Type.
On the Ribbon Insert tab, click on PivotChart.
If a cell within your data is active then your data should be selected automatically. Specify where you want your chart and click OK. A blank chart will appear.
In the PivotChart Field List, drag Type to the Axis box and Value to the Values box. By default you will see a bar chart. Right-click on the Chart Area and select Change Chart Type... and select Pie.
After manipulating chart components such as Legend, Title, Chart Area,, etc. you should be able to get to something like:
answered Dec 27 '18 at 1:59
Mark FitzgeraldMark Fitzgerald
3681211
Thank you Mark, I will try it out.
– Felipe Oriani
Dec 28 '18 at 11:32
add a comment |
A pivot chart will allow you to display Type totals without showing two items of the same Type.
On the Ribbon Insert tab, click on PivotChart.
If a cell within your data is active then your data should be selected automatically. Specify where you want your chart and click OK. A blank chart will appear.
In the PivotChart Field List, drag Type to the Axis box and Value to the Values box. By default you will see a bar chart. Right-click on the Chart Area and select Change Chart Type... and select Pie.
After manipulating chart components such as Legend, Title, Chart Area,, etc. you should be able to get to something like:
answered Dec 27 '18 at 1:59
Mark FitzgeraldMark Fitzgerald
3681211
Thank you Mark, I will try it out.
– Felipe Oriani
Dec 28 '18 at 11:32
add a comment |
A pivot chart will allow you to display Type totals without showing two items of the same Type.
On the Ribbon Insert tab, click on PivotChart.
If a cell within your data is active then your data should be selected automatically. Specify where you want your chart and click OK. A blank chart will appear.
In the PivotChart Field List, drag Type to the Axis box and Value to the Values box. By default you will see a bar chart. Right-click on the Chart Area and select Change Chart Type... and select Pie.
After manipulating chart components such as Legend, Title, Chart Area,, etc. you should be able to get to something like:
answered Dec 27 '18 at 1:59
Mark FitzgeraldMark Fitzgerald
3681211
A pivot chart will allow you to display Type totals without showing two items of the same Type.
On the Ribbon Insert tab, click on PivotChart.
If a cell within your data is active then your data should be selected automatically. Specify where you want your chart and click OK. A blank chart will appear.
In the PivotChart Field List, drag Type to the Axis box and Value to the Values box. By default you will see a bar chart. Right-click on the Chart Area and select Change Chart Type... and select Pie.
After manipulating chart components such as Legend, Title, Chart Area,, etc. you should be able to get to something like:
answered Dec 27 '18 at 1:59
Mark FitzgeraldMark Fitzgerald
3681211
answered Dec 27 '18 at 1:59
Mark FitzgeraldMark Fitzgerald
3681211
answered Dec 27 '18 at 1:59
Mark FitzgeraldMark Fitzgerald
3681211
answered Dec 27 '18 at 1:59
Mark FitzgeraldMark Fitzgerald
3681211
3681211
Thank you Mark, I will try it out.
– Felipe Oriani
Dec 28 '18 at 11:32
add a comment |
Thank you Mark, I will try it out.
– Felipe Oriani
Dec 28 '18 at 11:32
Thank you Mark, I will try it out.
– Felipe Oriani
Dec 28 '18 at 11:32
Thank you Mark, I will try it out.
– Felipe Oriani
Dec 28 '18 at 11:32
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%2f1387803%2fchart-on-excel-with-grouped-data%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
A pivot chart may be useful.
– Mark Fitzgerald
Dec 26 '18 at 13:34