Excel 2013 Chart - Multiple Series on Pivot ChartExcel coloured line chart for grouped data?How should I...
How can I highlight parts in a screenshot
How can I handle a player who pre-plans arguments about my rulings on RAW?
Misplaced tyre lever - alternatives?
Canadian citizen, on US no-fly list. What can I do in order to be allowed on flights which go through US airspace?
How can I conditionally format my HTML table?
PTIJ: What dummy is the Gemara referring to?
How to get the first element while continue streaming?
PTIJ: Mordechai mourning
Can a space-faring robot still function over a billion years?
Practical reasons to have both a large police force and bounty hunting network?
Is there any relevance to Thor getting his hair cut other than comedic value?
is 'sed' thread safe
I've given my players a lot of magic items. Is it reasonable for me to give them harder encounters?
Deal the cards to the players
Was it really inappropriate to write a pull request for the company I interviewed with?
Why do phishing e-mails use faked e-mail addresses instead of the real one?
I can't die. Who am I?
Why is it "take a leak?"
How to mitigate "bandwagon attacking" from players?
How do we objectively assess if a dialogue sounds unnatural or cringy?
How to kill a localhost:8080
It doesn't matter the side you see it
Script that counts quarters, dimes, nickels, and pennies
“I had a flat in the centre of town, but I didn’t like living there, so …”
Excel 2013 Chart - Multiple Series on Pivot Chart
Excel coloured line chart for grouped data?How should I design time series data for ease-of-use by Excel Pivot Tables?Excel chart with year-to-year comparisonIs it possible to make a pivot chart a subset of pivot table?MS Excel - adding line to some series in stacked bar chartExcel pivot table - unable to get graph to display correctlyScatterplot of categorical values from pivot tableHorizontal Axis of Line Chart Does Not Adjust - ExcelDate axis with Pivot Chart (Excel 2016)Excel chart with multiple series based on pivot tablesHow to plot timeline chart with start and end date columns
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,47061831
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,47061831
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,47061831
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,47061831
asked Jul 18 '14 at 21:12
KingOfAllTradesKingOfAllTrades
234139
edited Dec 15 '17 at 23:27
Donald Duck
1,47061831
asked Jul 18 '14 at 21:12
KingOfAllTradesKingOfAllTrades
234139
edited Dec 15 '17 at 23:27
Donald Duck
1,47061831
edited Dec 15 '17 at 23:27
Donald Duck
1,47061831
edited Dec 15 '17 at 23:27
Donald Duck
1,47061831
1,47061831
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