Hi there,
Someone gave me this real hand way to make a waterfall chart, I mean a chart with stacked bars to show the cause of change of something.
now, the only thing I have to enter are the numbers in B40-B44 and all the graph than automatically updates. I can not show the graph because it is to large but I hope that you know what I mean. how does this thing works. I'm not really in to charts but I would like to understand.
thanks
Someone gave me this real hand way to make a waterfall chart, I mean a chart with stacked bars to show the cause of change of something.
now, the only thing I have to enter are the numbers in B40-B44 and all the graph than automatically updates. I can not show the graph because it is to large but I hope that you know what I mean. how does this thing works. I'm not really in to charts but I would like to understand.
| Cause of Change model.xls | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | |||
| 38 | |||||||||||
| 39 | Base Figures | Graph Details | |||||||||
| 40 | Begin Point | 5,000 | Begin Point | 0 | 0 | 5,000 | 5,000 | ||||
| 41 | Change 1 | 3,000 | Change 1 | 5000 | 5,000 | 8,000 | 8,000 | ||||
| 42 | Change 2 | (5,000) | Change 2 | 8000 | 8,000 | 3,000 | 3,000 | ||||
| 43 | Change 3 | 8,000 | Change 3 | 3000 | 3,000 | 11,000 | 11,000 | ||||
| 44 | Change 4 | (3,000) | Change 4 | 11000 | 11,000 | 8,000 | 8,000 | ||||
| 45 | End Point | 8,000 | End Point | 0 | 0 | 8,000 | 8,000 | ||||
Cause of Change | |||||||||||
thanks
