Jeffrey Mahoney

Waterfall Chart Automated

Jeffrey Mahoney

Well-known Member
Joined
May 31, 2015
Messages
1,830
Office Version
  1. 365
Platform
  1. Windows
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

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Maurice123

New Member
Joined
Jan 6, 2021
Messages
5
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
53,224
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,830
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?
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,123,177
Messages
5,600,160
Members
414,367
Latest member
dw970906

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top