Hi JC,
For 100 Bar/Column, I assume you are referring to the Percentage Bar Chart in ChartDirector terminology.
For this type of chart, it is by design that negative values are treated as if they are positive values.
In ChartDirector, the percentage of a value is defined as:
value / total * 100
In the above, the "total" is the sum of all values.
However, if there are both positive and negative values, it is possible the total will be 0, or a small value, such that the percentage is undefined (for total = 0) or is extremely large (say 100000000% for a very small total value). So this type of chart is not suitable for data that are bipolar.
If bipolar data are in fact present, different charting package will interpret it in different ways. For ChartDirector, it will compute and plot the percentages as if all values are positive.
If you would like any alternative presentation of data, you may consider to use a different chart type instead of using a "Percentage Bar Chart".
Hope this can help.
Regards
Peter Kwan |
Forum Home
Search
Message List
Post Message
100 Bar/Column