+ Reply to Thread
Results 1 to 4 of 4

Waterfall Chart - From a Starting Value. Six + or -'s. Steps up to Final Value

  1. #1
    Registered User
    Join Date
    08-18-2009
    Location
    Cincinnati
    MS-Off Ver
    Excel 2007
    Posts
    96

    Waterfall Chart - From a Starting Value. Six + or -'s. Steps up to Final Value

    All,

    Could you help with a waterfall graph. I have a starting revenue (say $100 million). I have an ending revenue (say $120 million). Of that $20 million variance there are 6 categories of variances that can be positive or negative.

    I'd like chart to step the $100 million with 6 variance categories up to the $120 million. The 6 variance categories can be positive or negative . But each next category is a continuation of the last one's.

    I attached a graph similar to what it's look like with some sample data. The bars are a graphic version - not a live formula - of how the graph should look.


    The tricky part is when it's a negative, the next category needs to continue from the bottom of the previous bar. If it's a positive, needs to continue from the top of the previous bar. And I would be repopulating the graph with other regions' data for a new graph for every region (and month). The 0's don't help either.

    Thoughts? Links? (I have been looking at links can can kind of get the chart to work... but not well. That's why I'm coming to you gurus).

    Thanks all.
    Attached Files Attached Files
    Last edited by bluerog; 01-31-2017 at 05:30 PM.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,554

    Re: Waterfall Chart - From a Starting Value. Six + or -'s. Steps up to Final Value

    I have a preference for Jon Peltier's tutorials, and he has what looks like a good one for waterfall charts. http://peltiertech.com/excel-waterfa...bridge-charts/ Have you tried following his tutorial?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    08-18-2009
    Location
    Cincinnati
    MS-Off Ver
    Excel 2007
    Posts
    96

    Re: Waterfall Chart - From a Starting Value. Six + or -'s. Steps up to Final Value

    Thanks. That was the best tutorial I've seen on waterfall charts. I'm good now.

  4. #4
    Registered User
    Join Date
    08-18-2009
    Location
    Cincinnati
    MS-Off Ver
    Excel 2007
    Posts
    96

    Re: Waterfall Chart - From a Starting Value. Six + or -'s. Steps up to Final Value

    If anyone needs, attached is the graph I used after going through the tutorial.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Waterfall Chart
    By wiewie002 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 01-15-2016, 11:30 AM
  2. Replies: 1
    Last Post: 11-14-2014, 06:01 AM
  3. Waterfall Chart - Adding text to chart from table
    By smudgepost in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-26-2014, 08:03 AM
  4. [SOLVED] Waterfall chart add-ins?
    By Miles in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 12-03-2013, 06:34 PM
  5. waterfall chart
    By nicko54 in forum Excel General
    Replies: 1
    Last Post: 02-19-2010, 12:50 PM
  6. [SOLVED] waterfall chart ... once again ...
    By SIGE in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 04-30-2005, 11:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1