Excel 2013 Chart - Multiple Series on Pivot Chart
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I have an Excel 2013 file that pulls data from a SharePoint list. The goal is to create a dashboard that can be refreshed easily and without formatting or updating formulas of any type.
The list/table has a date column that I break down to Year and Month and that is filtered in the pivot table so only the current year shows (I can live with a once-a-year update).
I would like to get a multi-series line chart with each category as a series (line), a Y axis with the sum of the hours for that category, and an X axis with the month).
I can get close with a simple pivot chart, but instead of multiple series, it "groups" the different categories with the month along the X axis. Here is what I can currently make:
What I need it to look like is this:
While I could create the table as shown on the second image, it would have to be updated as the list allows users to enter any value they want for the Category, so the number of categories (and therefore columns) can be unlimited.
I hope I have made this clear and understandable. Again, there may be some manual solutions, and I can make those happen, but this is designed to be a management tool for constant review and therefore needs to be as automated as possible.
microsoft-excel charts microsoft-excel-2013
edited Dec 15 '17 at 23:27
Donald Duck
1,47861831
asked Jul 18 '14 at 21:12
KingOfAllTradesKingOfAllTrades
234139
add a comment |
I have an Excel 2013 file that pulls data from a SharePoint list. The goal is to create a dashboard that can be refreshed easily and without formatting or updating formulas of any type.
The list/table has a date column that I break down to Year and Month and that is filtered in the pivot table so only the current year shows (I can live with a once-a-year update).
I would like to get a multi-series line chart with each category as a series (line), a Y axis with the sum of the hours for that category, and an X axis with the month).
I can get close with a simple pivot chart, but instead of multiple series, it "groups" the different categories with the month along the X axis. Here is what I can currently make:
What I need it to look like is this:
While I could create the table as shown on the second image, it would have to be updated as the list allows users to enter any value they want for the Category, so the number of categories (and therefore columns) can be unlimited.
I hope I have made this clear and understandable. Again, there may be some manual solutions, and I can make those happen, but this is designed to be a management tool for constant review and therefore needs to be as automated as possible.
microsoft-excel charts microsoft-excel-2013
edited Dec 15 '17 at 23:27
Donald Duck
1,47861831
asked Jul 18 '14 at 21:12
KingOfAllTradesKingOfAllTrades
234139
2
Well, I found the answer in another question. Line chart for grouped data. It is a really simple fix. Take the field you want to break down as a series and put that in the "column labes" or as 2013 calls it the "Legend" box of the pivot table/chart.
– KingOfAllTrades
Jul 21 '14 at 17:29
add a comment |
I have an Excel 2013 file that pulls data from a SharePoint list. The goal is to create a dashboard that can be refreshed easily and without formatting or updating formulas of any type.
The list/table has a date column that I break down to Year and Month and that is filtered in the pivot table so only the current year shows (I can live with a once-a-year update).
I would like to get a multi-series line chart with each category as a series (line), a Y axis with the sum of the hours for that category, and an X axis with the month).
I can get close with a simple pivot chart, but instead of multiple series, it "groups" the different categories with the month along the X axis. Here is what I can currently make:
What I need it to look like is this:
While I could create the table as shown on the second image, it would have to be updated as the list allows users to enter any value they want for the Category, so the number of categories (and therefore columns) can be unlimited.
I hope I have made this clear and understandable. Again, there may be some manual solutions, and I can make those happen, but this is designed to be a management tool for constant review and therefore needs to be as automated as possible.
microsoft-excel charts microsoft-excel-2013
edited Dec 15 '17 at 23:27
Donald Duck
1,47861831
asked Jul 18 '14 at 21:12
KingOfAllTradesKingOfAllTrades
234139
I have an Excel 2013 file that pulls data from a SharePoint list. The goal is to create a dashboard that can be refreshed easily and without formatting or updating formulas of any type.
The list/table has a date column that I break down to Year and Month and that is filtered in the pivot table so only the current year shows (I can live with a once-a-year update).
I would like to get a multi-series line chart with each category as a series (line), a Y axis with the sum of the hours for that category, and an X axis with the month).
I can get close with a simple pivot chart, but instead of multiple series, it "groups" the different categories with the month along the X axis. Here is what I can currently make:
What I need it to look like is this:
While I could create the table as shown on the second image, it would have to be updated as the list allows users to enter any value they want for the Category, so the number of categories (and therefore columns) can be unlimited.
I hope I have made this clear and understandable. Again, there may be some manual solutions, and I can make those happen, but this is designed to be a management tool for constant review and therefore needs to be as automated as possible.
microsoft-excel charts microsoft-excel-2013
microsoft-excel charts microsoft-excel-2013
edited Dec 15 '17 at 23:27
Donald Duck
1,47861831
asked Jul 18 '14 at 21:12
KingOfAllTradesKingOfAllTrades
234139
edited Dec 15 '17 at 23:27
Donald Duck
1,47861831
asked Jul 18 '14 at 21:12
KingOfAllTradesKingOfAllTrades
234139
edited Dec 15 '17 at 23:27
Donald Duck
1,47861831
edited Dec 15 '17 at 23:27
Donald Duck
1,47861831
edited Dec 15 '17 at 23:27
Donald Duck
1,47861831
1,47861831
asked Jul 18 '14 at 21:12
KingOfAllTradesKingOfAllTrades
234139
asked Jul 18 '14 at 21:12
KingOfAllTradesKingOfAllTrades
234139
asked Jul 18 '14 at 21:12
KingOfAllTradesKingOfAllTrades
234139
234139
2
Well, I found the answer in another question. Line chart for grouped data. It is a really simple fix. Take the field you want to break down as a series and put that in the "column labes" or as 2013 calls it the "Legend" box of the pivot table/chart.
– KingOfAllTrades
Jul 21 '14 at 17:29
add a comment |
2
Well, I found the answer in another question. Line chart for grouped data. It is a really simple fix. Take the field you want to break down as a series and put that in the "column labes" or as 2013 calls it the "Legend" box of the pivot table/chart.
– KingOfAllTrades
Jul 21 '14 at 17:29
2
2
Well, I found the answer in another question. Line chart for grouped data. It is a really simple fix. Take the field you want to break down as a series and put that in the "column labes" or as 2013 calls it the "Legend" box of the pivot table/chart.
– KingOfAllTrades
Jul 21 '14 at 17:29
Well, I found the answer in another question. Line chart for grouped data. It is a really simple fix. Take the field you want to break down as a series and put that in the "column labes" or as 2013 calls it the "Legend" box of the pivot table/chart.
– KingOfAllTrades
Jul 21 '14 at 17:29
add a comment |
1 Answer
1
active
oldest
votes
The pivot chart layout is connected to the pivot table.
You might want to move the "Category" fields to the column labels category instead of Row labels.
If you really need to keep the looks of the original table, copy it first.
answered Nov 17 '14 at 11:09
sicarius92sicarius92
111
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%2f784993%2fexcel-2013-chart-multiple-series-on-pivot-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
The pivot chart layout is connected to the pivot table.
You might want to move the "Category" fields to the column labels category instead of Row labels.
If you really need to keep the looks of the original table, copy it first.
answered Nov 17 '14 at 11:09
sicarius92sicarius92
111
add a comment |
The pivot chart layout is connected to the pivot table.
You might want to move the "Category" fields to the column labels category instead of Row labels.
If you really need to keep the looks of the original table, copy it first.
answered Nov 17 '14 at 11:09
sicarius92sicarius92
111
add a comment |
The pivot chart layout is connected to the pivot table.
You might want to move the "Category" fields to the column labels category instead of Row labels.
If you really need to keep the looks of the original table, copy it first.
answered Nov 17 '14 at 11:09
sicarius92sicarius92
111
The pivot chart layout is connected to the pivot table.
You might want to move the "Category" fields to the column labels category instead of Row labels.
If you really need to keep the looks of the original table, copy it first.
answered Nov 17 '14 at 11:09
sicarius92sicarius92
111
answered Nov 17 '14 at 11:09
sicarius92sicarius92
111
answered Nov 17 '14 at 11:09
sicarius92sicarius92
111
answered Nov 17 '14 at 11:09
sicarius92sicarius92
111
111
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%2f784993%2fexcel-2013-chart-multiple-series-on-pivot-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
2
Well, I found the answer in another question. Line chart for grouped data. It is a really simple fix. Take the field you want to break down as a series and put that in the "column labes" or as 2013 calls it the "Legend" box of the pivot table/chart.
– KingOfAllTrades
Jul 21 '14 at 17:29