How to plot a scatter graphHow to create a scatter chart?How to create dynamic Scatter Plot/Matrix with...
Seemingly unused edef prior to an ifx mysteriously affects the outcome of the ifx. Why?
The Defining Moment
Why is it that the natural deduction method can't test for invalidity?
Is there really no use for MD5 anymore?
What happened to Captain America in Endgame?
Controversial area of mathematics
How do I reattach a shelf to the wall when it ripped out of the wall?
Unexpected email from Yorkshire Bank
Why does academia still use scientific journals and not peer-reviewed government funded alternatives?
Is there an official tutorial for installing Ubuntu 18.04+ on a device with an SSD and an additional internal hard drive?
How to make a pipeline wait for end-of-file or stop after an error?
Why other Westeros houses don't use wildfire?
What language was spoken in East Asia before Proto-Turkic?
How can I place the product on a social media post better?
Apply MapThread to all but one variable
Does holding a wand and speaking its command word count as V/S/M spell components?
Is it possible to determine the symmetric encryption method used by output size?
how to find the equation of a circle given points of the circle
Why was the Spitfire's elliptical wing almost uncopied by other aircraft of World War 2?
Please, smoke with good manners
What makes accurate emulation of old systems a difficult task?
Packing rectangles: Does rotation ever help?
What's the polite way to say "I need to urinate"?
How to solve constants out of the internal energy equation?
How to plot a scatter graph
How to create a scatter chart?How to create dynamic Scatter Plot/Matrix with labels and categories on both axis in Excel 2010?Lines over data in Excel 2007 Scatter GraphExcel Scatter Chart with category based formatting of pointsPlot multiple sets of x,y data on a single chartAdd an area to a scatter plot in ExcelScatter plot combined with line chartAligning Stacked Bar Chart w/ Scatter Plot DataExcel - X-axis issues when combining x-y scatter and column chartsHow to plot event times in a LibreOffice-calc chart
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I feel embarrassed to even ask this question. I'm unable to plot a scatter graph based upon the data I have.
My data looks like
A B C D
Mon Tues Weds Thrs
2 9 6 9
8 9 9 8
5 4 7 3
6 2 4 4
2 7 9 5
This is a representation of how I'd like the chart to be (the image doesn't try to correlate to the demo values in the above table)
I'm unable to do so. The below shows my effort
For some reason, it doesn't show Monday and furthermore I can't get the axis correct... I can't get (as per the image above) an Axis with days of the week!
What am I doing wrong?
microsoft-excel charts
asked yesterday
MyDaftQuestionsMyDaftQuestions
49741944
add a comment |
I feel embarrassed to even ask this question. I'm unable to plot a scatter graph based upon the data I have.
My data looks like
A B C D
Mon Tues Weds Thrs
2 9 6 9
8 9 9 8
5 4 7 3
6 2 4 4
2 7 9 5
This is a representation of how I'd like the chart to be (the image doesn't try to correlate to the demo values in the above table)
I'm unable to do so. The below shows my effort
For some reason, it doesn't show Monday and furthermore I can't get the axis correct... I can't get (as per the image above) an Axis with days of the week!
What am I doing wrong?
microsoft-excel charts
asked yesterday
MyDaftQuestionsMyDaftQuestions
49741944
The graph you produce is off the data you have. There is only one "Monday" so all inputs for that day will be above that day. The Scatter Graph you included as your desired result requires sub sections of Monday, maybe an hour value.
– Kevin Anthony Oppegaard Rose
yesterday
add a comment |
I feel embarrassed to even ask this question. I'm unable to plot a scatter graph based upon the data I have.
My data looks like
A B C D
Mon Tues Weds Thrs
2 9 6 9
8 9 9 8
5 4 7 3
6 2 4 4
2 7 9 5
This is a representation of how I'd like the chart to be (the image doesn't try to correlate to the demo values in the above table)
I'm unable to do so. The below shows my effort
For some reason, it doesn't show Monday and furthermore I can't get the axis correct... I can't get (as per the image above) an Axis with days of the week!
What am I doing wrong?
microsoft-excel charts
asked yesterday
MyDaftQuestionsMyDaftQuestions
49741944
I feel embarrassed to even ask this question. I'm unable to plot a scatter graph based upon the data I have.
My data looks like
A B C D
Mon Tues Weds Thrs
2 9 6 9
8 9 9 8
5 4 7 3
6 2 4 4
2 7 9 5
This is a representation of how I'd like the chart to be (the image doesn't try to correlate to the demo values in the above table)
I'm unable to do so. The below shows my effort
For some reason, it doesn't show Monday and furthermore I can't get the axis correct... I can't get (as per the image above) an Axis with days of the week!
What am I doing wrong?
microsoft-excel charts
microsoft-excel charts
asked yesterday
MyDaftQuestionsMyDaftQuestions
49741944
asked yesterday
MyDaftQuestionsMyDaftQuestions
49741944
asked yesterday
MyDaftQuestionsMyDaftQuestions
49741944
asked yesterday
MyDaftQuestionsMyDaftQuestions
49741944
asked yesterday
MyDaftQuestionsMyDaftQuestions
49741944
49741944
The graph you produce is off the data you have. There is only one "Monday" so all inputs for that day will be above that day. The Scatter Graph you included as your desired result requires sub sections of Monday, maybe an hour value.
– Kevin Anthony Oppegaard Rose
yesterday
add a comment |
The graph you produce is off the data you have. There is only one "Monday" so all inputs for that day will be above that day. The Scatter Graph you included as your desired result requires sub sections of Monday, maybe an hour value.
– Kevin Anthony Oppegaard Rose
yesterday
The graph you produce is off the data you have. There is only one "Monday" so all inputs for that day will be above that day. The Scatter Graph you included as your desired result requires sub sections of Monday, maybe an hour value.
– Kevin Anthony Oppegaard Rose
yesterday
The graph you produce is off the data you have. There is only one "Monday" so all inputs for that day will be above that day. The Scatter Graph you included as your desired result requires sub sections of Monday, maybe an hour value.
– Kevin Anthony Oppegaard Rose
yesterday
add a comment |
1 Answer
1
active
oldest
votes
Do what you have been doing, then click Switch Row/Column on the chart design ribbon. Then format the X axis to have only full numbers.
XY scatter charts need numeric data for both axes. You have category data (week days) instead of numbers.
The sample chart in your question is more sophisticated. It looks like there are some kind time aspects for each week day.
This can be done in a XY scatter chart with date/time values on the horizontal (X) axis, but your data source would have to contain X/Y pairs for each data point. Right now it doesn't.
In addition to that you would have to introduce a helper series that plots a zero Y value in select positions on the X axis, then use data labels below these data points to mark out the day names.
answered yesterday
teylynteylyn
17.6k22539
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%2f1429902%2fhow-to-plot-a-scatter-graph%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
Do what you have been doing, then click Switch Row/Column on the chart design ribbon. Then format the X axis to have only full numbers.
XY scatter charts need numeric data for both axes. You have category data (week days) instead of numbers.
The sample chart in your question is more sophisticated. It looks like there are some kind time aspects for each week day.
This can be done in a XY scatter chart with date/time values on the horizontal (X) axis, but your data source would have to contain X/Y pairs for each data point. Right now it doesn't.
In addition to that you would have to introduce a helper series that plots a zero Y value in select positions on the X axis, then use data labels below these data points to mark out the day names.
answered yesterday
teylynteylyn
17.6k22539
add a comment |
Do what you have been doing, then click Switch Row/Column on the chart design ribbon. Then format the X axis to have only full numbers.
XY scatter charts need numeric data for both axes. You have category data (week days) instead of numbers.
The sample chart in your question is more sophisticated. It looks like there are some kind time aspects for each week day.
This can be done in a XY scatter chart with date/time values on the horizontal (X) axis, but your data source would have to contain X/Y pairs for each data point. Right now it doesn't.
In addition to that you would have to introduce a helper series that plots a zero Y value in select positions on the X axis, then use data labels below these data points to mark out the day names.
answered yesterday
teylynteylyn
17.6k22539
add a comment |
Do what you have been doing, then click Switch Row/Column on the chart design ribbon. Then format the X axis to have only full numbers.
XY scatter charts need numeric data for both axes. You have category data (week days) instead of numbers.
The sample chart in your question is more sophisticated. It looks like there are some kind time aspects for each week day.
This can be done in a XY scatter chart with date/time values on the horizontal (X) axis, but your data source would have to contain X/Y pairs for each data point. Right now it doesn't.
In addition to that you would have to introduce a helper series that plots a zero Y value in select positions on the X axis, then use data labels below these data points to mark out the day names.
answered yesterday
teylynteylyn
17.6k22539
Do what you have been doing, then click Switch Row/Column on the chart design ribbon. Then format the X axis to have only full numbers.
XY scatter charts need numeric data for both axes. You have category data (week days) instead of numbers.
The sample chart in your question is more sophisticated. It looks like there are some kind time aspects for each week day.
This can be done in a XY scatter chart with date/time values on the horizontal (X) axis, but your data source would have to contain X/Y pairs for each data point. Right now it doesn't.
In addition to that you would have to introduce a helper series that plots a zero Y value in select positions on the X axis, then use data labels below these data points to mark out the day names.
answered yesterday
teylynteylyn
17.6k22539
edited yesterday
answered yesterday
teylynteylyn
17.6k22539
answered yesterday
teylynteylyn
17.6k22539
answered yesterday
teylynteylyn
17.6k22539
17.6k22539
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%2f1429902%2fhow-to-plot-a-scatter-graph%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
The graph you produce is off the data you have. There is only one "Monday" so all inputs for that day will be above that day. The Scatter Graph you included as your desired result requires sub sections of Monday, maybe an hour value.
– Kevin Anthony Oppegaard Rose
yesterday