Home

Working with a waterfall chart.

%3CLINGO-SUB%20id%3D%22lingo-sub-825701%22%20slang%3D%22en-US%22%3EWorking%20with%20a%20waterfall%20chart.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-825701%22%20slang%3D%22en-US%22%3E%3CP%3EWorking%20with%20a%20waterfall%20chart.%20Using%20days%20of%20the%20week%20as%20horizontal%20axis%2C%20and%20trying%20to%20use%20times%20of%20day%20as%20vertical%20axis.%20%26nbsp%3BI%20can%E2%80%99t%20get%20the%20order%20to%20%E2%80%98flow%E2%80%99%3B%20say%2C%20events%20on%20a%20Sunday%20at%209.00%20hrs%2C%2012.00%20hrs%2C%2019.00%20hrs.%20Am%20using%20a%20MacBook%20-%20any%20thoughts%3Athinking_face%3A%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-825701%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-825914%22%20slang%3D%22en-US%22%3ERe%3A%20Working%20with%20a%20waterfall%20chart.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-825914%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F399287%22%20target%3D%22_blank%22%3E%40Bjcannon4499%3C%2FA%3E%26nbsp%3B%2C%20can%20you%20upload%20a%20workbook%20with%20a%20data%20sample%20and%20mock%20up%20what%20you%20would%20like%20to%20achieve%3F%20Maybe%20use%20the%20drawing%20tools%20or%20an%20image%20of%20a%20similar%20chart.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-828853%22%20slang%3D%22en-US%22%3ERe%3A%20Working%20with%20a%20waterfall%20chart.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-828853%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%220%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%3EDate%3C%2FTD%3E%3CTD%3EDay%3C%2FTD%3E%3CTD%3ETime%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E29%2F09%2F2014%3C%2FTD%3E%3CTD%3EMonday%3C%2FTD%3E%3CTD%3E16%3A00%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E18%2F11%2F2014%3C%2FTD%3E%3CTD%3ETuesday%3C%2FTD%3E%3CTD%3E1%3A10%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E23%2F11%2F2014%3C%2FTD%3E%3CTD%3ESunday%3C%2FTD%3E%3CTD%3E19%3A23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E24%2F11%2F2014%3C%2FTD%3E%3CTD%3EMonday%3C%2FTD%3E%3CTD%3E19%3A18%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E28%2F01%2F2015%3C%2FTD%3E%3CTD%3EWednesday%3C%2FTD%3E%3CTD%3E23%3A00%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E17%2F11%2F2016%3C%2FTD%3E%3CTD%3EThursday%3C%2FTD%3E%3CTD%3E17%3A00%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E30%2F05%2F2017%3C%2FTD%3E%3CTD%3ETuesday%3C%2FTD%3E%3CTD%3E11%3A00%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E25%2F02%2F2018%3C%2FTD%3E%3CTD%3ESunday%3C%2FTD%3E%3CTD%3E9%3A55%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E31%2F08%2F2018%3C%2FTD%3E%3CTD%3EFriday%3C%2FTD%3E%3CTD%3E19%3A12%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E16%2F09%2F2018%3C%2FTD%3E%3CTD%3ESunday%3C%2FTD%3E%3CTD%3E16%3A15%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E10%2F11%2F2018%3C%2FTD%3E%3CTD%3ESaturday%3C%2FTD%3E%3CTD%3E21%3A00%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOkay%2C%20I%20may%20be%20off%20beam%20and%20and%20happy%20to%20be%20corrected.%20%26nbsp%3BYou%20see%20there%20are%203%20times%20for%20Sunday%20-%20these%20are%20three%20events%20and%20I'm%20trying%20to%20depict%20these%20in%20ascending%20time%20order%20(so%20the%20vert%20axis%20has%20to%20be%20in%2024%20hour%20clock%20format%20-%20in%20can%20be%20in%202hr%20increments%2C%20or%20whatever)%20and%20the%20horizontal%20is%20the%20seven%20days%20of%20the%20week.%20%26nbsp%3BAny%20thoughts%2Fassistance%20greatly%20received!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Bjcannon4499
New Contributor

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

2 Replies

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.

Highlighted

@Ingeborg Hawighorst 

 

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!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies