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:
https://jsfiddle.net/fcg9scma/
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
Thanks
2 Answers, 1 is accepted
Rank 1
In addition, trying to divide out by the big numbers and then multiply the labels to adjust the scale does not work either.
This is due to the last column being a "summary" column. It would incorrectly add/subtract the numbers at the wrong scale.
I think the only way to get around that is to plot one set of values and display another one on the labels.
For example, you can bind your series to pre-processed "value" field and configure the labels to show the "displayValue" field.
I hope this helps.
Regards,
T. Tsonev
Telerik