Results 1 to 3 of 3

Thread: Excel Dynamic Waterfall Chart

  1. #1
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10

    Excel Dynamic Waterfall Chart

    How many times have we contemplated creating a waterfall chart, and then just let it go, cause those calculations were too complicated.....

    Thanks to our friend Kris, we have a dummy's easy-to-use waterfall chart that gives results such as these.....

    Enter your data in the columns on the top left (run the alignment macro if needed for the labels).... and viola! there's your waterfall....


    Attached Images Attached Images
    Attached Files Attached Files
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  2. #2
    Junior Member
    Join Date
    Nov 2013
    Posts
    1
    Rep Power
    0
    I'm new to VBA and trying to update the alignment macro in this file. I'm using it to look at top 5/bottom 5 values but my values are too large for the data labels. Is there a way to revise the code so it formats the data labels with commas and no decimals? Thanks in advance!

  3. #3
    Banned
    Join Date
    Oct 2015
    Posts
    1
    Rep Power
    0
    You can devide your values by 1,000 or 1,000,000
    Other way is you can use Waterfall Chart Studio Excel add-in Waterfall Chart Studio
    By the way, waterfall charts become the standard type in Excel 2016. But if you use older version of Excel, Waterfall Chart Studio will be useful for you.
    You can see how the add-in works here https://youtu.be/Z1pavJW8_e8

Similar Threads

  1. Create A Dynamic Border Using Excel Native Formula
    By mahmoud-lee in forum Excel Help
    Replies: 4
    Last Post: 06-02-2013, 06:07 AM
  2. Dynamic Chart Query
    By leopaulc in forum Excel Help
    Replies: 6
    Last Post: 11-26-2012, 04:50 PM
  3. Excel Chart Showing Values on Angle: Nightingale Chart
    By Rajan_Verma in forum Rajan Verma's Corner
    Replies: 0
    Last Post: 10-17-2012, 06:39 PM
  4. Replies: 1
    Last Post: 05-20-2012, 12:23 PM
  5. Allign Waterfall Chart Label
    By S M C in forum Excel Help
    Replies: 0
    Last Post: 09-08-2011, 05:10 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •