[Solved] Set time intervals for Y axis of chart

[sivousplais]

Hello! Thanks for your time.

I'm attempting to make a scatterplot on the Spreadsheet Application. I am using time as my Y-axis and have the intervals as follows:

Time (PM)

4:20
4:40
5:00
5:20
5:40
6:00

When I input this data into the chart, it creates a Y axis where the times are measured at random intervals between the aforementioned times instead of displaying the exact times. When I go to format the axis, I can change the range but there is nowhere for me to assign the values displayed on the Y axis with their exact times. How can I change the format so the times match the measurements?

Thanks!

[MrProgrammer]

How can I change the format so the times match the measurements?

You may be able to find an answer in Calc Guide Chapter 3: Creating Charts and Graphs. This reference will help you create the charts that you want. Otherwise I need to see your data layout, formatting, and values. Attach a spreadsheet demonstrating the situation (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the spreadsheet itself). I will not help further unless you attach a spreadsheet document.

[sivousplais]

Hey, thanks for taking the time to reply.

Its just an example/hypothetical chart; there's no sensitive information on here.

I'm measuring whether or not (yes/no) a behavior occurred (perseveration) in 20-minute increments.

I have the data laid out in lines 4-7 and have taken the data from lines 10-17 to make the chart there. Its as close as I can get it; really the only thing is figuring out how to match the times on the y-axis with the data from lines 10-17.

Appreciate your time.

[MrProgrammer]

really the only thing is figuring out how to match the times on the y-axis with the data from lines 10-17.

Double click the chart → Format → Axis → Y axis → Scale → Minimum → 16:20:00 → Maximum → 18:00:00 → Major interval → 00:20:00 → Numbers → Uncheck Source format → Format code → HH:MM AM/PM → OK. I'm sure scales are explained in the book I linked for you.

My version of Calc doesn't display the first point when I set the minimum to 16:20:00 but does if I set it to 16:19:59.90. You can't get the times displayed without PM unless you use format code HH:MM. 12-hour times without AM/PM are meaningless. Then you'll see the hours as 16, 17, …. The Y axis uses a linear scale so you can have it display the time every 20 minutes. But if your values in rows 12 through 17 aren't linearly spaced (yours are) the Y axis labels won't match them.

If this solved your problem please go to your first post use the Edit ✏️ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know