Forum Discussion

Bjcannon4499's avatar
Bjcannon4499
Copper Contributor
Aug 27, 2019

Working with a waterfall chart.

Working with a waterfall chart. Using days of the week as horizontal axis, and trying to use times of day as vertical axis.  I can’t get the order to ‘flow’; say, events on a Sunday at 9.00 hrs, 12.00 hrs, 19.00 hrs. Am using a MacBook - any thoughts🤔

excel

2 Replies

  • IngeborgHawighorst's avatar
    IngeborgHawighorst
    MVP
    Aug 28, 2019

    Hello Bjcannon4499 , can you upload a workbook with a data sample and mock up what you would like to achieve? Maybe use the drawing tools or an image of a similar chart.

    • Bjcannon4499's avatar
      Bjcannon4499
      Copper Contributor
      Aug 29, 2019

      IngeborgHawighorst 

       

      DateDayTime
      29/09/2014Monday16:00
      18/11/2014Tuesday1:10
      23/11/2014Sunday19:23
      24/11/2014Monday19:18
      28/01/2015Wednesday23:00
      17/11/2016Thursday17:00
      30/05/2017Tuesday11:00
      25/02/2018Sunday9:55
      31/08/2018Friday19:12
      16/09/2018Sunday16:15
      10/11/2018Saturday21:00

       

       

      Okay, I may be off beam and and happy to be corrected.  You see there are 3 times for Sunday - these are three events and I'm trying to depict these in ascending time order (so the vert axis has to be in 24 hour clock format - in can be in 2hr increments, or whatever) and the horizontal is the seven days of the week.  Any thoughts/assistance greatly received!

Resources