Hey,
I am trying to construct a stacked waterfall that supports:
I have followed the guide on peltiertech (http://peltiertech.com/WordPress/excel-waterfall-charts-bridge-charts/)
Stacked Columns for Positive and Negative Data and managed to built the chart for one series.
However, when I try to expand the chart and formulas to incorporate several series I run into trouble.
The "difficult" part is that every series can be split on the x-axis and I would assume that I need 4 columns (up>0, up<0, down>0, down<0) for each series.
Case1:
Start 100
Series1 -50
Series2 -75
Here we should have:
Series1 (Down>0):-50
Series2 (Down>0):-50 and (Down<0):-25
Case2:
Start -100
Series1: +150
Series2: 50
Here we should have:
Series1: (Up<0):+100 and (Up>0):+50
Series2: (Up>0):+50
Do you know of any easy way to adapt the formulas from peltiertech to this multiple series example?
Great thanks for any help.
Cheers
I am trying to construct a stacked waterfall that supports:
- Multiple series
- Can go below zero
I have followed the guide on peltiertech (http://peltiertech.com/WordPress/excel-waterfall-charts-bridge-charts/)
Stacked Columns for Positive and Negative Data and managed to built the chart for one series.
However, when I try to expand the chart and formulas to incorporate several series I run into trouble.
The "difficult" part is that every series can be split on the x-axis and I would assume that I need 4 columns (up>0, up<0, down>0, down<0) for each series.
Case1:
Start 100
Series1 -50
Series2 -75
Here we should have:
Series1 (Down>0):-50
Series2 (Down>0):-50 and (Down<0):-25
Case2:
Start -100
Series1: +150
Series2: 50
Here we should have:
Series1: (Up<0):+100 and (Up>0):+50
Series2: (Up>0):+50
Do you know of any easy way to adapt the formulas from peltiertech to this multiple series example?
Great thanks for any help.
Cheers