How do you change the axis for time in charts?
up vote
1
down vote
favorite
Using google sheets, I am trying to plot times between 9pm and 3am (sleeping time every night), with the x axis being each calendar date/day.
But the scale puts items just after midnight at the bottom of the y-axis (y is the time axis, x axis is the day), because of the timing (0:10) is 10 minutes later than midnight and I want it to reflect that on the graph.
The two graphs are waking and sleeping times.
Waking makes sense, sleeping does not:
The only way seems to be put an if else and change format completely converting time format to integer and then multiplying to get a number close to 24 hrs (and then 1am is 25, 2 am is 26, etc).
Is there not a simpler was to change the axis for time? Does no one else log times either side of midnight?
The two images below show the formula, and the chart data:
charts google-sheets google-visualization
edited Nov 18 at 3:25
teylyn
21.5k33352
asked Nov 17 at 19:37
mrj
516
add a comment |
up vote
1
down vote
favorite
Using google sheets, I am trying to plot times between 9pm and 3am (sleeping time every night), with the x axis being each calendar date/day.
But the scale puts items just after midnight at the bottom of the y-axis (y is the time axis, x axis is the day), because of the timing (0:10) is 10 minutes later than midnight and I want it to reflect that on the graph.
The two graphs are waking and sleeping times.
Waking makes sense, sleeping does not:
The only way seems to be put an if else and change format completely converting time format to integer and then multiplying to get a number close to 24 hrs (and then 1am is 25, 2 am is 26, etc).
Is there not a simpler was to change the axis for time? Does no one else log times either side of midnight?
The two images below show the formula, and the chart data:
charts google-sheets google-visualization
edited Nov 18 at 3:25
teylyn
21.5k33352
asked Nov 17 at 19:37
mrj
516
@WhiteHat, apologies, there is no code. I have added to more screenshots, showing the google sheets fromula, and the input into the chart.
– mrj
Nov 17 at 20:00
add a comment |
up vote
1
down vote
favorite
up vote
1
down vote
favorite
Using google sheets, I am trying to plot times between 9pm and 3am (sleeping time every night), with the x axis being each calendar date/day.
But the scale puts items just after midnight at the bottom of the y-axis (y is the time axis, x axis is the day), because of the timing (0:10) is 10 minutes later than midnight and I want it to reflect that on the graph.
The two graphs are waking and sleeping times.
Waking makes sense, sleeping does not:
The only way seems to be put an if else and change format completely converting time format to integer and then multiplying to get a number close to 24 hrs (and then 1am is 25, 2 am is 26, etc).
Is there not a simpler was to change the axis for time? Does no one else log times either side of midnight?
The two images below show the formula, and the chart data:
charts google-sheets google-visualization
edited Nov 18 at 3:25
teylyn
21.5k33352
asked Nov 17 at 19:37
mrj
516
Using google sheets, I am trying to plot times between 9pm and 3am (sleeping time every night), with the x axis being each calendar date/day.
But the scale puts items just after midnight at the bottom of the y-axis (y is the time axis, x axis is the day), because of the timing (0:10) is 10 minutes later than midnight and I want it to reflect that on the graph.
The two graphs are waking and sleeping times.
Waking makes sense, sleeping does not:
The only way seems to be put an if else and change format completely converting time format to integer and then multiplying to get a number close to 24 hrs (and then 1am is 25, 2 am is 26, etc).
Is there not a simpler was to change the axis for time? Does no one else log times either side of midnight?
The two images below show the formula, and the chart data:
charts google-sheets google-visualization
charts google-sheets google-visualization
edited Nov 18 at 3:25
teylyn
21.5k33352
asked Nov 17 at 19:37
mrj
516
edited Nov 18 at 3:25
teylyn
21.5k33352
asked Nov 17 at 19:37
mrj
516
edited Nov 18 at 3:25
teylyn
21.5k33352
edited Nov 18 at 3:25
teylyn
21.5k33352
edited Nov 18 at 3:25
teylyn
21.5k33352
21.5k33352
asked Nov 17 at 19:37
mrj
516
asked Nov 17 at 19:37
mrj
516
asked Nov 17 at 19:37
mrj
516
516
@WhiteHat, apologies, there is no code. I have added to more screenshots, showing the google sheets fromula, and the input into the chart.
– mrj
Nov 17 at 20:00
add a comment |
@WhiteHat, apologies, there is no code. I have added to more screenshots, showing the google sheets fromula, and the input into the chart.
– mrj
Nov 17 at 20:00
@WhiteHat, apologies, there is no code. I have added to more screenshots, showing the google sheets fromula, and the input into the chart.
– mrj
Nov 17 at 20:00
@WhiteHat, apologies, there is no code. I have added to more screenshots, showing the google sheets fromula, and the input into the chart.
– mrj
Nov 17 at 20:00
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2fstackoverflow.com%2fquestions%2f53354836%2fhow-do-you-change-the-axis-for-time-in-charts%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
@WhiteHat, apologies, there is no code. I have added to more screenshots, showing the google sheets fromula, and the input into the chart.
– mrj
Nov 17 at 20:00