Is there a way to draw bars in a waterfall chart NOT to scale?
I have a Waterfall chart that has a large starting value (thousands) and then 5 bars that are small numbers (hundreds or less), and then finally a summary bar (which is large).
How can I draw it so the middle bars are large, and the outer bars are "not to scale".
I have created a jsfiddle to illustrate the problem:
The ideal solution would be to have the middle bars be larger, and yet maintain the size of the outside bars. I tried just dividing the large numbers by 10, but it seems to be a band-aid solution that does not work for a large variety of numbers. Is there a solution that doesn't involve trying to derive a percentage to reduce the data values for the large numbers (while re-adjusting the text in the labels) ? I