zaterdag 7 februari 2015

Excel: Double Waterfall Chart

I made a waterfall chart after the model of +Jon Peltier. After adding another two lines and linking them to the secondary axis I was able to create a double waterfall chart.



Here are my data:

Values End Before After Values End Before After
Initial € 500,00 € 500,00 Initial            100            100
First € 100,00 € 500,00 € 600,00 First               20             100             120
Second € 200,00 € 600,00 € 400,00 Second             -10             120             110
Third € 150,00 € 400,00 € 550,00 Third                 5             110             115
Fourth € 100,00 € 550,00 € 450,00 Fourth               15             115             130
Fifth € 125,00 € 450,00 € 575,00 Fifth             -10             130             120
Last € 575,00 Last            120

Een reactie plaatsen