Hi,
I'm trying to create a template for a waterfall chart.
The data look something like this:
<tbody>
</tbody>
The base for Company1, 2 and 3 would be 'hidden' in the chart, so basically the chart starts off with the base budget, then grows or decreases by the deviations until it reaches the Forecast, which is the sum of base+deviations
But the number of columns, (dev1, dev2, etc..) might vary.
I'm hoping to create a dynamic chart where the number of columns can easily be changed.
Moreover, the deviations might be positive or negative.
Not sure how to approach this, creating a template where all the deviations are positive is easy enough, same if they're all negative, but I'm struggling when they can be either positive or negative.
Anyone with any bright ideas?
I'm trying to create a template for a waterfall chart.
The data look something like this:
Base | Dev1 | Dev2 | Dev3 | |
Budget | 240 | 0 | 0 | 20 |
Company1 | 240 | 40 | 0 | 0 |
Company2 | 240 | 0 | 20 | 0 |
Company3 | 240 | -20 | 0 | 40 |
Forecast 1 | 320 | 0 | 0 | 0 |
<tbody>
</tbody>
The base for Company1, 2 and 3 would be 'hidden' in the chart, so basically the chart starts off with the base budget, then grows or decreases by the deviations until it reaches the Forecast, which is the sum of base+deviations
But the number of columns, (dev1, dev2, etc..) might vary.
I'm hoping to create a dynamic chart where the number of columns can easily be changed.
Moreover, the deviations might be positive or negative.
Not sure how to approach this, creating a template where all the deviations are positive is easy enough, same if they're all negative, but I'm struggling when they can be either positive or negative.
Anyone with any bright ideas?