SetExploded
Overview | Properties | Methods
Call this method to explode a particular pie slice.
Syntax
long = PieChartObject.SetExploded([Index As Long = -1])
The SetExploded method syntax has the following parts:
|
Part |
Description |
|
Index |
Zero (0) based index of the data elements (pie slices) in the pie chart. Set this to -1 (or do not specify the index at all) to explode the collected pie slice. |
|
long |
Returns a long indicating the success or failure of the operation. Zero (0) is returned if successful, otherwise a non-zero value is returned. |
Returns
A long which indicates the success/failure of the operation. Zero (0) is returned if successful, otherwise a non-zero value is returned. If an error occurs you can use this return value as the argument for GetErrorText in order to retrieve a relevant text error message, or alternatively you can rem out the "On Error Resume Next" statement and observe the thrown exception for a description of the error.
Remarks
Call this function to explode a pie element or the collected element.
If you specify a data element to be exploded and the element ends up being collected it will not be exploded (unless the collected data element is set up to be exploded). However, if you were to decrease the limit at which elements are collected by calling SetCollectedLimit and the same pie slice is no longer a collected element it will then be exploded. In otherwords, it remembers that it is supposed to be exploded.
You MUST call AddData before exploding pie elements.
See Also: SetCollectedLimit | SetCollectedProp