ChartSeries Class
The definition for a series, and the values of it.
Syntax
Namespace: FlexCel.Core
public class ChartSeries
Constructors
Name | Description |
---|---|
ChartSeries | Overloaded ChartSeries ChartSeries(String, String, String) ChartSeries(String, String, String, Object, Object[], Object[], String[], String[], Int32, Int32, Int32) |
Properties
Name | Description |
---|---|
TitleDefinition | Formula or text defining the Series caption. Start with an "=" sign to enter a formula. |
DataDefinition | Formula defining the series. For example, "=A1:A5". Start with an "=" sign to enter a formula. Note that if the Series doesn't have a formula and only values (for example {1,2,3}), this property will be null and the result will be in DataValues |
CategoriesDefinition | Formula defining the Series Categories (normally the x Axis). Start with an "=" sign to enter a formula. Note that if the Series doesn't have a formula and only values, this property will be null and the result will be in CategoriesValues |
TitleValue | Evaluated text of the title. |
DataValues | Actual values for the series. |
DataValuesHidden | True if all the DataValues are from hidden cells. When this is true, the length of DataValues is 0. |
CategoriesValues | Actual values for the Series Categories (normally the x Axis). Note that category axis can contain multi-level labels. In those cases, CategoriesValues will just report all levels separated by carriage returns. To see the different levels as an array, use CategoriesValuesArray |
CategoriesValuesArray | Actual values for the Series Categories (normally the x Axis). This property is similar to CategoriesValues but if the labels have multiple levels, it will return a bi-dimensional array with one row per level. |
DataFormats | Format on the cell where the data is. So for example if you are charting a range A1:A3, this property will return an array with the numeric format strings for A1, A2 and A3. This format is applied to the data if the data format for the axis or the label is null. Each value in the array holds the format for one data point in the chart. |
CategoriesFormats | Format on the cell where the data is. So for example if you are charting a range A1:A3, this property will return an array with the numeric format strings for A1, A2 and A3. This format is applied to the data if the data format for the axis or the label is null. Each value in the array holds the format for one data point in the chart. |
CategoriesFormatsArray | Format on the cell where the data is. So for example if you are charting a range A1:A3, this property will return an array with the numeric format strings for A1, A2 and A3. This format is applied to the data if the data format for the axis or the label is null. Each value in the array holds the format for one data point in the chart. |
ChartOptionsIndex | Index to the ChartOptions object that applies to this series. Note that in xlsx charts, this is the number of subchart where the series is. So when setting series, you don't need to specify the ChartOptionIndex: FlexCel will use the number of subchart no matter what you specify here. |
SeriesIndex | Index of this series on the file. |
SeriesNumber | Series number as shown on the Legend box. This might be different from the SeriesIndex if the order of the series is changed. |
Options | Options for this series and their data points. -1 means the whole series, and n is options for the n-point. |
LegendOptions | Options for the legend entry associated with this series. (when legend is showing series), or with a point on the series. (when legend is showing all the entries on series[0], for example on pie charts) |
HorizontalErrorBars | Returns the horizontal error bar options, if the chart has error bars. If the chart doesn't have them, then null will be returned. |
VerticalErrorBars | Returns the vertical error bar options, if the chart has error bars. If the chart doesn't have them, then null will be returned. |