|
Question about zero values |
Posted by Helio on Jun-11-2011 07:21 |
|
Hi, i was wondering if there's a way to hide zero values from the pie chart,
but still show them on the legend,
so the reader will know all the option there exists.
Im using the NoValue, but them it disappear from both: the pie and the legend.
Thanks |
Re: Question about zero values |
Posted by Peter Kwan on Jun-13-2011 22:47 |
|
Hi,
You may use LegendBox.addKey2 to add the legend key for the missing sectors back. An example in VB/VBScript would be like:
For i = 0 To Ubound(data)
If data(i) = cd.NoValue Then Call c.getLegend().addKey2((i + 1) * 10000, labels(i), cd.DataColor + i)
Next
Hope this can help.
Regards
Peter Kwan |
|