Hi Johnny,
The chart you need is a "floating box" chart, of which the waterfall chart is an example. In a
floating box chart, you need just to specify the top and bottom of each of the bars (or
boxes). For example, for your case, the data would be:
double[] boxTop = {2, 3, 3, 5, 5, 6, 7};
double[] boxBottom = {0, 2, 0, 3, 0, 0, 0};
string[] labels = {"Current\\nValuation", "BBB", "CCC", "DDD", "EEE", "FFF", "GGG"};
(As I am not sure which programming language you are using, in the above example, I just
randomly choose to use C#.)
The waterfall chart is just an example where the boxTop and boxBottom are computed from
another data array. In actual applications, you can obtain and compute the boxTop and
boxBottom data in any way you like.
Hope this can help.
Regards
Peter Kwan |