ChartXValueCollection class

ChartXValueCollection class

Represents a collection of X values for a chart series.

Remarks

All items of the collection other than null must have the same ChartXValue.value_type.

The collection allows only changing X values. To add or insert new values to a chart series, or remove values, the appropriate methods of the ChartSeries class can be used.

Indexers

NameDescription
__getitem__(index)Gets or sets the X value at the specified index.

Properties

NameDescription
countGets the number of items in this collection.

Examples

Shows how to get chart series data.

doc = Document()
builder = DocumentBuilder()

shape = builder.insert_chart(ChartType.COLUMN, 432, 252)
chart = shape.chart
series = chart.series[0]

min_value = sys.float_info.max
min_value_index = 0
max_value = sys.float_info.max
max_value_index = 0

for i in range(0, series.y_values.count):
    # Clear individual format of all data points.
    # Data points and data values are one - to - one in column charts.
    series.data_points[i].clear_format()

    # Get Y value.
    y_value = series.y_values[i].double_value
    if y_value < min_value:
        min_value = y_value
        min_value_index = i

    if y_value > max_value:
        max_value = y_value
        max_value_index = i

# Change colors of the max and min values.
series.data_points[min_value_index].format.fill.fore_color = Color.red
series.data_points[max_value_index].format.fill.fore_color = Color.green

doc.save(ARTIFACTS_DIR + "Charts.GetChartSeriesData.docx");

See Also

ChartXValue class ChartXValueType enumeration