How to plot 3D graphs in Excel from CSV data?
I have data formatted like this in a csv file:
a, 1, 4, 6.0
a, 2, 42, 16.0
a, 5, 14, 69.3
a, 11, 4, 7.0
b, 1, 45, 6.0
b, 2, 45, 1.9
b, 9, 2, 4.4
b, 11, 4, 7.9
lines with first parameter a is one set of data, and first parameter b represents another set.
My aim is to plot two lines on the same graph, one with points
(1, 4, 6.0), (2, 42, 16.0), (5, 14, 69.3), (11, 4, 7.0)
and the other with points
(1, 45, 6.0), (2, 45, 1.9), (9, 2, 4.4), (11, 4, 7.9)
I am able to import the data directly in MS Excel, but am not sure how to plot them. How can I plot this data?
microsoft-excel charts csv
edited Sep 27 '14 at 18:40
Kenster
4,89021933
asked Oct 21 '12 at 21:58
MoebMoeb
4043914
add a comment |
I have data formatted like this in a csv file:
a, 1, 4, 6.0
a, 2, 42, 16.0
a, 5, 14, 69.3
a, 11, 4, 7.0
b, 1, 45, 6.0
b, 2, 45, 1.9
b, 9, 2, 4.4
b, 11, 4, 7.9
lines with first parameter a is one set of data, and first parameter b represents another set.
My aim is to plot two lines on the same graph, one with points
(1, 4, 6.0), (2, 42, 16.0), (5, 14, 69.3), (11, 4, 7.0)
and the other with points
(1, 45, 6.0), (2, 45, 1.9), (9, 2, 4.4), (11, 4, 7.9)
I am able to import the data directly in MS Excel, but am not sure how to plot them. How can I plot this data?
microsoft-excel charts csv
edited Sep 27 '14 at 18:40
Kenster
4,89021933
asked Oct 21 '12 at 21:58
MoebMoeb
4043914
Can you elaborate on what you mean by a 3D graph? Are you referring to graphing something in 3 dimensional space (like elevation contours) or are you simply wanting to encode a third variable in your chart for each data point? I think this is a subtle, but important distinction.
– dav
Oct 23 '12 at 11:44
add a comment |
I have data formatted like this in a csv file:
a, 1, 4, 6.0
a, 2, 42, 16.0
a, 5, 14, 69.3
a, 11, 4, 7.0
b, 1, 45, 6.0
b, 2, 45, 1.9
b, 9, 2, 4.4
b, 11, 4, 7.9
lines with first parameter a is one set of data, and first parameter b represents another set.
My aim is to plot two lines on the same graph, one with points
(1, 4, 6.0), (2, 42, 16.0), (5, 14, 69.3), (11, 4, 7.0)
and the other with points
(1, 45, 6.0), (2, 45, 1.9), (9, 2, 4.4), (11, 4, 7.9)
I am able to import the data directly in MS Excel, but am not sure how to plot them. How can I plot this data?
microsoft-excel charts csv
edited Sep 27 '14 at 18:40
Kenster
4,89021933
asked Oct 21 '12 at 21:58
MoebMoeb
4043914
I have data formatted like this in a csv file:
a, 1, 4, 6.0
a, 2, 42, 16.0
a, 5, 14, 69.3
a, 11, 4, 7.0
b, 1, 45, 6.0
b, 2, 45, 1.9
b, 9, 2, 4.4
b, 11, 4, 7.9
lines with first parameter a is one set of data, and first parameter b represents another set.
My aim is to plot two lines on the same graph, one with points
(1, 4, 6.0), (2, 42, 16.0), (5, 14, 69.3), (11, 4, 7.0)
and the other with points
(1, 45, 6.0), (2, 45, 1.9), (9, 2, 4.4), (11, 4, 7.9)
I am able to import the data directly in MS Excel, but am not sure how to plot them. How can I plot this data?
microsoft-excel charts csv
microsoft-excel charts csv
edited Sep 27 '14 at 18:40
Kenster
4,89021933
asked Oct 21 '12 at 21:58
MoebMoeb
4043914
edited Sep 27 '14 at 18:40
Kenster
4,89021933
asked Oct 21 '12 at 21:58
MoebMoeb
4043914
edited Sep 27 '14 at 18:40
Kenster
4,89021933
edited Sep 27 '14 at 18:40
Kenster
4,89021933
edited Sep 27 '14 at 18:40
Kenster
4,89021933
4,89021933
asked Oct 21 '12 at 21:58
MoebMoeb
4043914
asked Oct 21 '12 at 21:58
MoebMoeb
4043914
asked Oct 21 '12 at 21:58
MoebMoeb
4043914
4043914
Can you elaborate on what you mean by a 3D graph? Are you referring to graphing something in 3 dimensional space (like elevation contours) or are you simply wanting to encode a third variable in your chart for each data point? I think this is a subtle, but important distinction.
– dav
Oct 23 '12 at 11:44
add a comment |
Can you elaborate on what you mean by a 3D graph? Are you referring to graphing something in 3 dimensional space (like elevation contours) or are you simply wanting to encode a third variable in your chart for each data point? I think this is a subtle, but important distinction.
– dav
Oct 23 '12 at 11:44
Can you elaborate on what you mean by a 3D graph? Are you referring to graphing something in 3 dimensional space (like elevation contours) or are you simply wanting to encode a third variable in your chart for each data point? I think this is a subtle, but important distinction.
– dav
Oct 23 '12 at 11:44
Can you elaborate on what you mean by a 3D graph? Are you referring to graphing something in 3 dimensional space (like elevation contours) or are you simply wanting to encode a third variable in your chart for each data point? I think this is a subtle, but important distinction.
– dav
Oct 23 '12 at 11:44
add a comment |
2 Answers
2
active
oldest
votes
You didn't state what version of Excel you are using. This was done in Excel 2010, but should give you an idea how to do it enough to figure it out in another version.
After you've imported your data, select a cell with no data. Insert a blank chart. Then edit the chart data by choosing Select Data from the context menu. You will then add a series choosing A1 as the series name, then select the data row by row while holding Ctrl (this allows multi-select). This will plot the numbers in the order you stated. Do not just select all of the data from B1 to D4 or you will get an error.
Then do the same thing for b by adding another series.
answered Oct 22 '12 at 17:58
CharlieRBCharlieRB
20.5k44490
The OP is asking about 3D charts, as far as I can tell, although not clear exactly what kind.
– beroe
Sep 27 '14 at 18:49
1
This post is nearly 2-years old. At this point, I am not sure it makes a difference considering the OP hasn't given feedback. Nonetheless, you are right. They would need to simply change the chart type or properties to 3D.
– CharlieRB
Sep 28 '14 at 18:38
add a comment |
If you want a 3D scatter plot, you will have to use something like this macro, since 3D Scatter is not a build-in chart type. Or you could try R or some other plotting environment.
answered Sep 27 '14 at 18:48
beroeberoe
812515
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%2f490783%2fhow-to-plot-3d-graphs-in-excel-from-csv-data%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
You didn't state what version of Excel you are using. This was done in Excel 2010, but should give you an idea how to do it enough to figure it out in another version.
After you've imported your data, select a cell with no data. Insert a blank chart. Then edit the chart data by choosing Select Data from the context menu. You will then add a series choosing A1 as the series name, then select the data row by row while holding Ctrl (this allows multi-select). This will plot the numbers in the order you stated. Do not just select all of the data from B1 to D4 or you will get an error.
Then do the same thing for b by adding another series.
answered Oct 22 '12 at 17:58
CharlieRBCharlieRB
20.5k44490
The OP is asking about 3D charts, as far as I can tell, although not clear exactly what kind.
– beroe
Sep 27 '14 at 18:49
1
This post is nearly 2-years old. At this point, I am not sure it makes a difference considering the OP hasn't given feedback. Nonetheless, you are right. They would need to simply change the chart type or properties to 3D.
– CharlieRB
Sep 28 '14 at 18:38
add a comment |
You didn't state what version of Excel you are using. This was done in Excel 2010, but should give you an idea how to do it enough to figure it out in another version.
After you've imported your data, select a cell with no data. Insert a blank chart. Then edit the chart data by choosing Select Data from the context menu. You will then add a series choosing A1 as the series name, then select the data row by row while holding Ctrl (this allows multi-select). This will plot the numbers in the order you stated. Do not just select all of the data from B1 to D4 or you will get an error.
Then do the same thing for b by adding another series.
answered Oct 22 '12 at 17:58
CharlieRBCharlieRB
20.5k44490
The OP is asking about 3D charts, as far as I can tell, although not clear exactly what kind.
– beroe
Sep 27 '14 at 18:49
1
This post is nearly 2-years old. At this point, I am not sure it makes a difference considering the OP hasn't given feedback. Nonetheless, you are right. They would need to simply change the chart type or properties to 3D.
– CharlieRB
Sep 28 '14 at 18:38
add a comment |
You didn't state what version of Excel you are using. This was done in Excel 2010, but should give you an idea how to do it enough to figure it out in another version.
After you've imported your data, select a cell with no data. Insert a blank chart. Then edit the chart data by choosing Select Data from the context menu. You will then add a series choosing A1 as the series name, then select the data row by row while holding Ctrl (this allows multi-select). This will plot the numbers in the order you stated. Do not just select all of the data from B1 to D4 or you will get an error.
Then do the same thing for b by adding another series.
answered Oct 22 '12 at 17:58
CharlieRBCharlieRB
20.5k44490
You didn't state what version of Excel you are using. This was done in Excel 2010, but should give you an idea how to do it enough to figure it out in another version.
After you've imported your data, select a cell with no data. Insert a blank chart. Then edit the chart data by choosing Select Data from the context menu. You will then add a series choosing A1 as the series name, then select the data row by row while holding Ctrl (this allows multi-select). This will plot the numbers in the order you stated. Do not just select all of the data from B1 to D4 or you will get an error.
Then do the same thing for b by adding another series.
answered Oct 22 '12 at 17:58
CharlieRBCharlieRB
20.5k44490
edited Oct 22 '12 at 18:08
answered Oct 22 '12 at 17:58
CharlieRBCharlieRB
20.5k44490
answered Oct 22 '12 at 17:58
CharlieRBCharlieRB
20.5k44490
answered Oct 22 '12 at 17:58
CharlieRBCharlieRB
20.5k44490
20.5k44490
The OP is asking about 3D charts, as far as I can tell, although not clear exactly what kind.
– beroe
Sep 27 '14 at 18:49
1
This post is nearly 2-years old. At this point, I am not sure it makes a difference considering the OP hasn't given feedback. Nonetheless, you are right. They would need to simply change the chart type or properties to 3D.
– CharlieRB
Sep 28 '14 at 18:38
add a comment |
The OP is asking about 3D charts, as far as I can tell, although not clear exactly what kind.
– beroe
Sep 27 '14 at 18:49
1
This post is nearly 2-years old. At this point, I am not sure it makes a difference considering the OP hasn't given feedback. Nonetheless, you are right. They would need to simply change the chart type or properties to 3D.
– CharlieRB
Sep 28 '14 at 18:38
The OP is asking about 3D charts, as far as I can tell, although not clear exactly what kind.
– beroe
Sep 27 '14 at 18:49
The OP is asking about 3D charts, as far as I can tell, although not clear exactly what kind.
– beroe
Sep 27 '14 at 18:49
1
1
This post is nearly 2-years old. At this point, I am not sure it makes a difference considering the OP hasn't given feedback. Nonetheless, you are right. They would need to simply change the chart type or properties to 3D.
– CharlieRB
Sep 28 '14 at 18:38
This post is nearly 2-years old. At this point, I am not sure it makes a difference considering the OP hasn't given feedback. Nonetheless, you are right. They would need to simply change the chart type or properties to 3D.
– CharlieRB
Sep 28 '14 at 18:38
add a comment |
If you want a 3D scatter plot, you will have to use something like this macro, since 3D Scatter is not a build-in chart type. Or you could try R or some other plotting environment.
answered Sep 27 '14 at 18:48
beroeberoe
812515
add a comment |
If you want a 3D scatter plot, you will have to use something like this macro, since 3D Scatter is not a build-in chart type. Or you could try R or some other plotting environment.
answered Sep 27 '14 at 18:48
beroeberoe
812515
add a comment |
If you want a 3D scatter plot, you will have to use something like this macro, since 3D Scatter is not a build-in chart type. Or you could try R or some other plotting environment.
answered Sep 27 '14 at 18:48
beroeberoe
812515
If you want a 3D scatter plot, you will have to use something like this macro, since 3D Scatter is not a build-in chart type. Or you could try R or some other plotting environment.
answered Sep 27 '14 at 18:48
beroeberoe
812515
answered Sep 27 '14 at 18:48
beroeberoe
812515
answered Sep 27 '14 at 18:48
beroeberoe
812515
answered Sep 27 '14 at 18:48
beroeberoe
812515
812515
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%2f490783%2fhow-to-plot-3d-graphs-in-excel-from-csv-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
Can you elaborate on what you mean by a 3D graph? Are you referring to graphing something in 3 dimensional space (like elevation contours) or are you simply wanting to encode a third variable in your chart for each data point? I think this is a subtle, but important distinction.
– dav
Oct 23 '12 at 11:44