|
Pie Chart Problem |
Posted by Ricardo on Jun-19-2012 03:10 |
|
I'm making a pie chart using VB6, but 20 is returning data, how do I use for the rest TOP9 cluster in "OTHER"?
Tks,
Ricardo |
Re: Pie Chart Problem |
Posted by Peter Kwan on Jun-20-2012 00:55 |
|
Hi Ricardo,
You just need to group the reset of the values into one value. For example:
'Assume your data are in a dynamic array myData that can be redim
If Ubound(myData) > 9 Then
'Group all values > 9 to the 10th element
For i = 10 to Ubound(myData)
myData(9) = myData(9) + myData(i)
Next
ReDim Preserve myData(9)
'Change the 10th label to OTHER
ReDim Preserve myLabels(9)
myLabels(9) = "OTHER"
End If
Regards
Peter Kwan |
|