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. Data A section of the chart

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.
    – Tedinoz
    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.
    – Tedinoz
    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.
    – mmtunligit
  • 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.
    – Tedinoz
    20 hours ago
  • @Tedinoz that's kind of what I figured, but thanks for your help nonetheless
    – mmtunligit
    13 hours ago

Your Answer

mmtunligit is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.