Jeffrey Mahoney

Waterfall Chart Automated

Overview Discussion
Jeffrey Mahoney

Jeffrey Mahoney

Well-known Member
Joined
May 31, 2015
Messages
2,856
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...
Click to expand...

Read more about this Excel article...
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
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?
 
If you follow the link to the full article, at the bottom of the page is a link to the file.
 
Maurice123 said:
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?
Click to expand...
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.
 
You must log in or register to reply here.

Forum statistics

Threads
1,216,503
Messages
6,131,022
Members
449,616
Latest member
PsychoCube

Share this page

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
Back
Top