Waterfall chart

**wjviveen** · 11-20-2009, 02:56 AM

Hello,

Could anybody help me get my waterfall chart to work ? I have tried using the method from John Peltier i found in the forums. But i am doing something wrong ? I have attached the file with the data and the chart.
Somehow the chart will not cross the x axes ?

Thanks in advance for your help !

**JeanRage** · 11-20-2009, 03:03 AM

Hi,

Already followed what the MASTER John explains for waterfall charts ... with no difficulty ..

http://peltiertech.com/Excel/Charts/...lcrossing.html

HTH

**wjviveen** · 11-20-2009, 03:26 AM

Hi, that is the tutorial i tried to follow.
But apparently I am not smart enough ;-)

**wjviveen** · 11-20-2009, 10:56 AM

I have checked the tutorial again, but cant find what I am doing wrong ??
Somebody have any idea what i should check again ?

**Andy Pope** · 11-20-2009, 11:10 AM

Firstly we can not see you actual data as the cells are linked to a workbook on your pc.
Second why do you think there is a need to cross the zero line. Your data suggests everything is in the positive section.
Your starting amount is 28598
with the largest change being 255

Did you mess up comma and decimal characters?

**wjviveen** · 11-23-2009, 04:07 AM

Sorry for the linked numbers, i was under impression that i deleted the links.
I have attached a new file.
I cant figure out how to get it to look a genuine waterfall, with the positive and negative impacts ?

Sorry for the confusion.

**Andy Pope** · 11-23-2009, 04:54 AM

Again, you have no values that causes the waterfall to cross the zero axis.

If you format the series according to their descriptions you will get the waterfall chart.

The thing that maybe confusing you is that the columns inbetween endpoints are not clearly visible, due to the same values.

I have included a chart where the base line is 28,000.