C
Cade
Hi,
I'm required to do "waterfall" diagrams on a nearly daily basis at
work. My employer likes to show development in numbers this way. I'm
not even sure if this is the correct name (we name them here this way)
- I've also heard them as "Delta" or "Change" graphs:
The graph consists of vertical bars as follows
a] a starting bar showing the total value (for example 500 million
USD). This bar would start at zero and go to 500.
b] to the right of it is the next bar that only displays a change. For
example an increase in 2 million USD would start at the height where
the prior graph ended and would go up for the length of 2 million
worth. It only shows the change. In other words, this bar would show
nothing from 0 to 500 and would only be plotted from 500 to 502.
c] a decrease would start where the prior bar ended on the left and go
down the length of x USD worth
d] after n changes, there would be solid bar starting from zero again
just like the first one, showing the final number.
What is the official name of this kind of diagram?
Is there a way to do this easy in Excel? I came up with an algorithm
that calculates basically two bars that sit on top of each other in a
vertical bar diagram and then for the changes I have to hide (zero
border/no color)the bottom bar of each bar so that only the change is
displayed. This gets really tricky if the total goes over/under zero.
Any help in this is greatly appreciated.
Thanks,
Cade
I'm required to do "waterfall" diagrams on a nearly daily basis at
work. My employer likes to show development in numbers this way. I'm
not even sure if this is the correct name (we name them here this way)
- I've also heard them as "Delta" or "Change" graphs:
The graph consists of vertical bars as follows
a] a starting bar showing the total value (for example 500 million
USD). This bar would start at zero and go to 500.
b] to the right of it is the next bar that only displays a change. For
example an increase in 2 million USD would start at the height where
the prior graph ended and would go up for the length of 2 million
worth. It only shows the change. In other words, this bar would show
nothing from 0 to 500 and would only be plotted from 500 to 502.
c] a decrease would start where the prior bar ended on the left and go
down the length of x USD worth
d] after n changes, there would be solid bar starting from zero again
just like the first one, showing the final number.
What is the official name of this kind of diagram?
Is there a way to do this easy in Excel? I came up with an algorithm
that calculates basically two bars that sit on top of each other in a
vertical bar diagram and then for the changes I have to hide (zero
border/no color)the bottom bar of each bar so that only the change is
displayed. This gets really tricky if the total goes over/under zero.
Any help in this is greatly appreciated.
Thanks,
Cade