In a 3 variables graph, one variable stays at 0 even though its values aren't 0
I'm trying to make a 3-variables graph with Hours as the absciss, Light Intensity as the left ordinate and Water Temperature as the right ordinate.
I don't know why Light Intensity is fine, but Water Temperature is just a straight line (in orange) on the absciss instead of adjusting to the ordinate on the right.
Here is an image:
microsoft-excel
edited Nov 22 at 20:20
Run5k
10.8k72850
asked Nov 22 at 19:53
Bobren
1
add a comment |
I'm trying to make a 3-variables graph with Hours as the absciss, Light Intensity as the left ordinate and Water Temperature as the right ordinate.
I don't know why Light Intensity is fine, but Water Temperature is just a straight line (in orange) on the absciss instead of adjusting to the ordinate on the right.
Here is an image:
microsoft-excel
edited Nov 22 at 20:20
Run5k
10.8k72850
asked Nov 22 at 19:53
Bobren
1
What type of chart do you have? What happens if you make a chart with just the water temp?
– cybernetic.nomad
Nov 22 at 20:30
I just put text and numbers under it. The same thing happens when I make it into a board.Here's what happens if it's only hour and water temp: i.imgur.com/poyNehr.png
– Bobren
Nov 22 at 20:49
assuming your water values start in C3, use the following formula=ISNUMBER(C3). You are looking for a value of true. If you get a value of FALSE it means you have numbers that are entered as text. Numbers as text will be treated at 0
– Forward Ed
Nov 22 at 21:28
add a comment |
I'm trying to make a 3-variables graph with Hours as the absciss, Light Intensity as the left ordinate and Water Temperature as the right ordinate.
I don't know why Light Intensity is fine, but Water Temperature is just a straight line (in orange) on the absciss instead of adjusting to the ordinate on the right.
Here is an image:
microsoft-excel
edited Nov 22 at 20:20
Run5k
10.8k72850
asked Nov 22 at 19:53
Bobren
1
I'm trying to make a 3-variables graph with Hours as the absciss, Light Intensity as the left ordinate and Water Temperature as the right ordinate.
I don't know why Light Intensity is fine, but Water Temperature is just a straight line (in orange) on the absciss instead of adjusting to the ordinate on the right.
Here is an image:
microsoft-excel
microsoft-excel
edited Nov 22 at 20:20
Run5k
10.8k72850
asked Nov 22 at 19:53
Bobren
1
edited Nov 22 at 20:20
Run5k
10.8k72850
asked Nov 22 at 19:53
Bobren
1
edited Nov 22 at 20:20
Run5k
10.8k72850
edited Nov 22 at 20:20
Run5k
10.8k72850
edited Nov 22 at 20:20
Run5k
10.8k72850
10.8k72850
asked Nov 22 at 19:53
Bobren
1
asked Nov 22 at 19:53
Bobren
1
asked Nov 22 at 19:53
Bobren
1
1
What type of chart do you have? What happens if you make a chart with just the water temp?
– cybernetic.nomad
Nov 22 at 20:30
I just put text and numbers under it. The same thing happens when I make it into a board.Here's what happens if it's only hour and water temp: i.imgur.com/poyNehr.png
– Bobren
Nov 22 at 20:49
assuming your water values start in C3, use the following formula=ISNUMBER(C3). You are looking for a value of true. If you get a value of FALSE it means you have numbers that are entered as text. Numbers as text will be treated at 0
– Forward Ed
Nov 22 at 21:28
add a comment |
What type of chart do you have? What happens if you make a chart with just the water temp?
– cybernetic.nomad
Nov 22 at 20:30
I just put text and numbers under it. The same thing happens when I make it into a board.Here's what happens if it's only hour and water temp: i.imgur.com/poyNehr.png
– Bobren
Nov 22 at 20:49
assuming your water values start in C3, use the following formula=ISNUMBER(C3). You are looking for a value of true. If you get a value of FALSE it means you have numbers that are entered as text. Numbers as text will be treated at 0
– Forward Ed
Nov 22 at 21:28
What type of chart do you have? What happens if you make a chart with just the water temp?
– cybernetic.nomad
Nov 22 at 20:30
What type of chart do you have? What happens if you make a chart with just the water temp?
– cybernetic.nomad
Nov 22 at 20:30
I just put text and numbers under it. The same thing happens when I make it into a board.Here's what happens if it's only hour and water temp: i.imgur.com/poyNehr.png
– Bobren
Nov 22 at 20:49
I just put text and numbers under it. The same thing happens when I make it into a board.Here's what happens if it's only hour and water temp: i.imgur.com/poyNehr.png
– Bobren
Nov 22 at 20:49
assuming your water values start in C3, use the following formula
=ISNUMBER(C3). You are looking for a value of true. If you get a value of FALSE it means you have numbers that are entered as text. Numbers as text will be treated at 0– Forward Ed
Nov 22 at 21:28
assuming your water values start in C3, use the following formula
=ISNUMBER(C3). You are looking for a value of true. If you get a value of FALSE it means you have numbers that are entered as text. Numbers as text will be treated at 0– Forward Ed
Nov 22 at 21:28
add a comment |
1 Answer
1
active
oldest
votes
Unless you change it, water temp is using the left (primary) y-axis. The numbers are so small, that the graph seems to be a straight line (the first tick is 5000, so 20 will be less than a pixel = invisible).
Select the water graph, and change it to use the secondary Y-axis.
answered Nov 23 at 2:11
Aganju
8,42231335
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%2f1377669%2fin-a-3-variables-graph-one-variable-stays-at-0-even-though-its-values-arent-0%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
Unless you change it, water temp is using the left (primary) y-axis. The numbers are so small, that the graph seems to be a straight line (the first tick is 5000, so 20 will be less than a pixel = invisible).
Select the water graph, and change it to use the secondary Y-axis.
answered Nov 23 at 2:11
Aganju
8,42231335
add a comment |
Unless you change it, water temp is using the left (primary) y-axis. The numbers are so small, that the graph seems to be a straight line (the first tick is 5000, so 20 will be less than a pixel = invisible).
Select the water graph, and change it to use the secondary Y-axis.
answered Nov 23 at 2:11
Aganju
8,42231335
add a comment |
Unless you change it, water temp is using the left (primary) y-axis. The numbers are so small, that the graph seems to be a straight line (the first tick is 5000, so 20 will be less than a pixel = invisible).
Select the water graph, and change it to use the secondary Y-axis.
answered Nov 23 at 2:11
Aganju
8,42231335
Unless you change it, water temp is using the left (primary) y-axis. The numbers are so small, that the graph seems to be a straight line (the first tick is 5000, so 20 will be less than a pixel = invisible).
Select the water graph, and change it to use the secondary Y-axis.
answered Nov 23 at 2:11
Aganju
8,42231335
answered Nov 23 at 2:11
Aganju
8,42231335
answered Nov 23 at 2:11
Aganju
8,42231335
answered Nov 23 at 2:11
Aganju
8,42231335
8,42231335
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f1377669%2fin-a-3-variables-graph-one-variable-stays-at-0-even-though-its-values-arent-0%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
What type of chart do you have? What happens if you make a chart with just the water temp?
– cybernetic.nomad
Nov 22 at 20:30
I just put text and numbers under it. The same thing happens when I make it into a board.Here's what happens if it's only hour and water temp: i.imgur.com/poyNehr.png
– Bobren
Nov 22 at 20:49
assuming your water values start in C3, use the following formula
=ISNUMBER(C3). You are looking for a value of true. If you get a value of FALSE it means you have numbers that are entered as text. Numbers as text will be treated at 0– Forward Ed
Nov 22 at 21:28