Gannt Chart in Microsoft Excel
I'm trying to create a Gantt chart in Microsoft Excel that will show planned vs. actual project timelines. I started off with this tutorial:
https://www.smartsheet.com/blog/gantt-chart-excel
Which gave me a decent looking Gantt chart to start with. But I'd like to show planned versus actual on the same graph, so I went looking for a more detailed tutorial. I found a few that suggested plotting the 'planned' values on one axis and the 'actual' values on another axis, but whenever I try to do this, the planned values will not display correctly. I've asked coworkers, but no one is quite sure about what else to try.
I'd like to end up with something that looks like the bottom chart in this link:
https://stackoverflow.com/questions/41595560/excel-gantt-chart-planned-vs-actual
Here is the excel file I'm working with now:
https://drive.google.com/file/d/1rWnvPVeBaip5UKUf-93wKIjYoA40GvkV/view?usp=sharing
I'd essentially like to combine the green and red charts for each table onto one chart.
Any chart wizards have any suggestions for me?
microsoft-excel-2007 charts gantt
asked Jan 23 at 16:19
phoenix1bpkphoenix1bpk
62
add a comment |
I'm trying to create a Gantt chart in Microsoft Excel that will show planned vs. actual project timelines. I started off with this tutorial:
https://www.smartsheet.com/blog/gantt-chart-excel
Which gave me a decent looking Gantt chart to start with. But I'd like to show planned versus actual on the same graph, so I went looking for a more detailed tutorial. I found a few that suggested plotting the 'planned' values on one axis and the 'actual' values on another axis, but whenever I try to do this, the planned values will not display correctly. I've asked coworkers, but no one is quite sure about what else to try.
I'd like to end up with something that looks like the bottom chart in this link:
https://stackoverflow.com/questions/41595560/excel-gantt-chart-planned-vs-actual
Here is the excel file I'm working with now:
https://drive.google.com/file/d/1rWnvPVeBaip5UKUf-93wKIjYoA40GvkV/view?usp=sharing
I'd essentially like to combine the green and red charts for each table onto one chart.
Any chart wizards have any suggestions for me?
microsoft-excel-2007 charts gantt
asked Jan 23 at 16:19
phoenix1bpkphoenix1bpk
62
Your file link does not work. It says I need permission.
– teylyn
Jan 23 at 20:10
So sorry! I didn't realize Google defaulted to only sharing that file with people at my company. I've enabled sharing and stripped any confidential information from the file.
– phoenix1bpk
Jan 25 at 2:12
add a comment |
I'm trying to create a Gantt chart in Microsoft Excel that will show planned vs. actual project timelines. I started off with this tutorial:
https://www.smartsheet.com/blog/gantt-chart-excel
Which gave me a decent looking Gantt chart to start with. But I'd like to show planned versus actual on the same graph, so I went looking for a more detailed tutorial. I found a few that suggested plotting the 'planned' values on one axis and the 'actual' values on another axis, but whenever I try to do this, the planned values will not display correctly. I've asked coworkers, but no one is quite sure about what else to try.
I'd like to end up with something that looks like the bottom chart in this link:
https://stackoverflow.com/questions/41595560/excel-gantt-chart-planned-vs-actual
Here is the excel file I'm working with now:
https://drive.google.com/file/d/1rWnvPVeBaip5UKUf-93wKIjYoA40GvkV/view?usp=sharing
I'd essentially like to combine the green and red charts for each table onto one chart.
Any chart wizards have any suggestions for me?
microsoft-excel-2007 charts gantt
asked Jan 23 at 16:19
phoenix1bpkphoenix1bpk
62
I'm trying to create a Gantt chart in Microsoft Excel that will show planned vs. actual project timelines. I started off with this tutorial:
https://www.smartsheet.com/blog/gantt-chart-excel
Which gave me a decent looking Gantt chart to start with. But I'd like to show planned versus actual on the same graph, so I went looking for a more detailed tutorial. I found a few that suggested plotting the 'planned' values on one axis and the 'actual' values on another axis, but whenever I try to do this, the planned values will not display correctly. I've asked coworkers, but no one is quite sure about what else to try.
I'd like to end up with something that looks like the bottom chart in this link:
https://stackoverflow.com/questions/41595560/excel-gantt-chart-planned-vs-actual
Here is the excel file I'm working with now:
https://drive.google.com/file/d/1rWnvPVeBaip5UKUf-93wKIjYoA40GvkV/view?usp=sharing
I'd essentially like to combine the green and red charts for each table onto one chart.
Any chart wizards have any suggestions for me?
microsoft-excel-2007 charts gantt
microsoft-excel-2007 charts gantt
asked Jan 23 at 16:19
phoenix1bpkphoenix1bpk
62
asked Jan 23 at 16:19
phoenix1bpkphoenix1bpk
62
asked Jan 23 at 16:19
phoenix1bpkphoenix1bpk
62
asked Jan 23 at 16:19
phoenix1bpkphoenix1bpk
62
asked Jan 23 at 16:19
phoenix1bpkphoenix1bpk
62
62
Your file link does not work. It says I need permission.
– teylyn
Jan 23 at 20:10
So sorry! I didn't realize Google defaulted to only sharing that file with people at my company. I've enabled sharing and stripped any confidential information from the file.
– phoenix1bpk
Jan 25 at 2:12
add a comment |
Your file link does not work. It says I need permission.
– teylyn
Jan 23 at 20:10
So sorry! I didn't realize Google defaulted to only sharing that file with people at my company. I've enabled sharing and stripped any confidential information from the file.
– phoenix1bpk
Jan 25 at 2:12
Your file link does not work. It says I need permission.
– teylyn
Jan 23 at 20:10
Your file link does not work. It says I need permission.
– teylyn
Jan 23 at 20:10
So sorry! I didn't realize Google defaulted to only sharing that file with people at my company. I've enabled sharing and stripped any confidential information from the file.
– phoenix1bpk
Jan 25 at 2:12
So sorry! I didn't realize Google defaulted to only sharing that file with people at my company. I've enabled sharing and stripped any confidential information from the file.
– phoenix1bpk
Jan 25 at 2:12
add a comment |
0
active
oldest
votes
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%2f1397541%2fgannt-chart-in-microsoft-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f1397541%2fgannt-chart-in-microsoft-excel%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
Your file link does not work. It says I need permission.
– teylyn
Jan 23 at 20:10
So sorry! I didn't realize Google defaulted to only sharing that file with people at my company. I've enabled sharing and stripped any confidential information from the file.
– phoenix1bpk
Jan 25 at 2:12