waterfall

Awhile ago I was working for a company managing their budgets. My boss knew I was good with Excel and sent me a copy of a waterfall chart that was created by another person no longer employed by them. Apparently a few people tried to make changes to the chart to reflect the current budget and...

I am looking for a formula that evaluates start month for Project 1, determines it starts in November, determines number of months to complete and calculates number of transactions per month based off of those cells. Any help is much appreciated

https://www.teamgantt.com/waterfall-chart-and-excel-templateHello - I am using a waterfall excel document template (linked above from team gantt website. Whenever I go to delete rows that I do not need (I only 4 rows in addition to the start/end) it does not show the end number correctly/at...

Hello all, I'm trying to paste a Excel 2016 built-in 'waterfall' chart into PowerPoint 2016 (Paste Special > Paste Link > Microsoft Excel Chart Object) and the option to 'Paste Link' is grayed out and unavailable. Other charts work (i.e. Bar/Column/Pie) but not 'Waterfall' - does anyone know...

How do I do a waterfall chart?

Hi guys, I hope someone could help me on changing the scale of my waterfall as the movement is relative small comparing to the budget and actual. So I have budget number of £10K and the middle movements are in between £100K and £11K, if I want to show the movement in a bigger scale, how to...

Hi I have a waterfall chart with 5 metrics. But I'll use 2 of the metrics (see below) to simplify the question: <colgroup><col><col></colgroup><tbody> Baseline Sales Incremental Sales 10,000,000 5,000,000 </tbody> Question: when using a waterfall chart, if the baseline sales are $10m...

On the older style chart (waterfalls built from tutorials) I would be able to click the zero value on the horizontal axis and in axis options i would just change the width. But that doesn't work on these new waterfall charts. Also I'm not sure if I can create a second series on these charts to...

Hi So I have a waterfall chart. And here is the data: Want I want to have is the bars to the right of the black target column to descend, not ascend, to the point where they meet the final gray column. I have both the black and gray column set as "total". For the life of me I can't work...

Hello everyone! I am new at this website. I am currently working for a bank and I have to do loads of Waterfalls so I tought that I could automatize the process. Based on this website, http://www.contextures.com/excelwaterfallchart.html , I started recording my moves with VBA to get to the...

Greetings all! I'm trying to create a report that will allow me to walk from 2016 sales to 2017 sales. I need to create a waterfall graph as well as a pivot that shows: 2016 Base add: New Sales Upsells Less: Lost Sales Downsells Total should equal 2017 Sales. I also need to show this from...

Hi all, I'm new in here, but hope that I can get some help! I have a problem with the colors in the new waterfall chart in excel 2016, where I'd like to automate the bar colors. For example, if the value is negative (bar goes down) I would like the bar to be green and for positive values (bar...

I have an entity in a project that receives quarterly but inconsistent cashflows until the entity's IRR = 10%. The distribution amount is subject to available cash so one quarter's distribution could be as low as 200k or as high as whatever is available subject to 10% irr cap. Entity will...

Hey All, In Excel 2007, trying to graph two waterfalls on the same page. If I were graphing two groups together and do not want two separate waterfalls. Excel Waterfall Charts (Bridge Charts) | Peltier Tech Blog | Excel Charts Does anyone have a template or advice? JV SDG

Would like assistance finalizing a waterfall tab in an excel model. Model already includes tabs to define cash flow, debt payments, etc. Need help working a contract's waterfall description into excel. Have a good start, but need assistance finalizing. Let me know if you can help.. Thanks.