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

1. ## 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.

2. ## 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?

3. ## 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. ## 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.

#### Thread Information

##### Users Browsing this Thread

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

#### 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