How to reverse the y-axis in google sheets when the y-axis is time of day?

So I'm trying to make a Marey graph, and I have it mostly figured out, but I can't figure out how to get it so that 12 AM is followed by 1 AM and so on, currently it starts at 12 AM, then goes to 11 PM and so on down the graph. I found this answer for a workaround, but I don't know how to get it to work with times of day instead of raw numbers. Any help would be appreciated. Here's a picture of my data, and what the chart looks like. the times in column A are just there to make it so that the chart covers an entire day, but my problem was happening without it.

New contributor
mmtunligit is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
• Hi and welcome. You're making a Marey graph. These have some pretty specific needs - would you please edit your answer to include a sample of your data, and an example of the graph output that you are expecting. Are you trying to use a "Timeline" chart, a "Scatter" graph (for an "X-Y" plot") or something else? Have you looked at Observable's Marey charts such as Marey trains using d3. 2 days ago
• Hi. How are you entering this data. Are they times, date/times, timestamps, or text? All the more important to have a sample of your data. 2 days ago
• @Tedinoz I have updated my post to include pictures. I looked through that link you gave, but I do not know how to code, and cannot parse what is happening there. If there's a simple way to use it while just changing station names and data points, I don't see it. yesterday
• The question that you referenced measures metres on the Y axis - that is, numbers. The answer involves creating a negative number and then applying a `custom number format` to display negative as positive (and vice versa). Where date/times values are concerned (such as your scenario) the idea of negative and positive are meaningless, and in any event, `custom date formats` don't recognise negative values. In brief, I (and that's just my opinion) don't think that you can reverse the Y axis where dates are concerned. 20 hours ago
• @Tedinoz that's kind of what I figured, but thanks for your help nonetheless 13 hours ago