Jeffrey Mahoney

Waterfall Chart Automated

Jeffrey Mahoney

Well-known Member
Joined
May 31, 2015
Messages
1,824
Jeffrey Mahoney submitted a new Excel article:

Waterfall Chart Automated - 18 point Waterfall Chart with Dynamic Ranges and Automatic Chart Update

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 failed. I thought, because I had created thousands of charts before this, that I was going to return the update in a matter of minutes. I was wrong. I bashed the numbers into place after looking at...

Read more about this Excel article...
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Maurice123

New Member
Joined
Jan 6, 2021
Messages
4
Office Version
  1. 365
Platform
  1. Windows
Wow Jeffrey, that is quite interesting stuff as I work with waterfall's allot.

Is this something what can be downloaded to have a look?
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
50,873
Office Version
  1. 365
Platform
  1. Windows
If you follow the link to the full article, at the bottom of the page is a link to the file.
 

Jeffrey Mahoney

Well-known Member
Joined
May 31, 2015
Messages
1,824
Wow Jeffrey, that is quite interesting stuff as I work with waterfall's allot.

Is this something what can be downloaded to have a look?
As Fluff said, I uploaded the file so you can use it for free.

When I needed this the most, I was making several changes a day. It used to take a person over an hour to get the new labels and values updated before I automated it. They may have been somewhat of a neophyte, but still, it saved me tons of time.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,780
Messages
5,574,211
Members
412,576
Latest member
abdulla88
Top