6 Replies Latest reply on Jul 10, 2018 6:18 AM by Vishnu Sekhar

    Hourly Time on X-Axis, Please Help

    Sneha Darsi

      Hi All,

      I'm working on this view that shows time elapsed from start to end from a daily 24-hour perspective. Right now, it's mostly the way I need it to be except for the X-Axis times. I attached the workbook and as you can see, it just keeps on replicating "3AM 9AM, 3PM 9PM", which also creates all that space on the right side. The goal is to have the X-Axis timings look like the image below, where the bars match up to the start/end times on the X-Axis. But because the hours are duplicating, the bars are not matching up. I'm having trouble in figuring out a way to get it like it is in the image. I would appreciate any help on the matter. Thank you very much!



      Update: I've tried using Edit X-Axis (Hari's suggestion) and changing the tick marks/date range, but there is still the problem of duplication. This creates problems with the bars matching up. Is there any way to get rid of the duplication? To only show one 24 hour cycle as opposed to 2 or 3? Thank you again!