UltraChart.PieChart.ColumnIndex = 0
This topic discusses useful information that will help you to ensure that your data is rendered properly in the 3D pie chart.
While the Chart control allows you to easily point the chart to your own custom data, it is important that you are supplying the appropriate amount and type of data that the chart requires. If the data does not meet the minimum requirements based on the type of chart that you are using, an error will be generated.
The following is a list of data requirements for 3D pie charts:
The data set contains one numeric column. A numeric column is any DataColumn containing only values that can be interpreted as numbers.
The column that you want to use for wedges in the chart must be specified by setting the ColumnIndex property to 0 (see the code below). To automatically search the data, set this property to -1. In this case, the first numeric column encountered will be used for the wedge values.
UltraChart.PieChart.ColumnIndex = 0If you are binding the 3D pie chart to a series object, see Requirements for Series Binding for information on the series binding requirements.
The chart data is rendered using the following rules:
Only one numeric column is displayed in the chart.
Each row represents a wedge in the chart. The value for this row in the correct column (the column matching the ColumnIndex property) will be assigned to the corresponding wedge in the chart.
The first string column encountered in the data will be used for row labels.
The column specified through the ColumnIndex property is the only column used for values in the chart. If the ColumnIndex property is not set, the first filtered column (or row) will be used.
Optionally, a labels column can be included in the data source to associate wedges with names or descriptions. These labels can be displayed in the chart legend or in the labels displayed next to each wedge:
UltraChart.PieChart3D.Labels.FormatString = "<ITEM_LABEL>: <DATA_VALUE:#> (<PERCENT_VALUE:#>%)"The data values do not need to be percentages, as the sum of the data values in the column is used to calculate the percentage applicable to each row.
Negative data values are treated as non-negative (by taking their absolute value) for this purpose.
You can include or exclude any column from the chart using the UltraChart.Data. IncludeColumn method.
See below for an example data set, along with the rendered 3D pie chart.
