Chart
Overview
Chart is a class in Aspose.Cells FOSS for Python.
Represents a chart in a worksheet.
This class provides 4 methods for working with Chart objects in Python programs.
Available methods include: __init__, add_axis, add_series, copy.
All public members are accessible to any Python application after installing the Aspose.Cells FOSS for Python package.
Properties: NSeries, View3D, axes, bar_direction, box_gap_width, box_show_inner_points, and 35 more.
Properties
| Name | Type | Access | Description |
|---|---|---|---|
type | `` | Read | Gets the type. |
title | `` | Read/Write | Gets or sets the title. |
category_data | `` | Read/Write | Gets or sets the category data. |
show_legend | `` | Read/Write | Gets or sets the show legend. |
legend_position | `` | Read/Write | Gets or sets the legend position. |
smooth | `` | Read/Write | Gets or sets the smooth. |
n_series | `` | Read | Gets the n series. |
NSeries | `` | Read | PascalCase alias of n_series. |
grouping | `` | Read/Write | Gets or sets the grouping. |
bar_direction | `` | Read/Write | Gets or sets the bar direction. |
gap_width | `` | Read/Write | Gets or sets the gap width. |
overlap | `` | Read/Write | Gets or sets the overlap. |
vary_colors | `` | Read/Write | Gets or sets the vary colors. |
first_slice_angle | `` | Read/Write | Gets or sets the first slice angle. |
is_of_pie | `` | Read/Write | Gets or sets the is of pie. |
of_pie_type | `` | Read/Write | Gets or sets the of pie type. |
second_pie_size | `` | Read/Write | Gets or sets the second pie size. |
quartile_method | `` | Read/Write | Gets or sets the quartile method. |
box_show_mean_line | `` | Read/Write | Gets or sets the box show mean line. |
box_show_mean_marker | `` | Read/Write | Gets or sets the box show mean marker. |
box_show_inner_points | `` | Read/Write | Gets or sets the box show inner points. |
box_show_outlier_points | `` | Read/Write | Gets or sets the box show outlier points. |
box_gap_width | `` | Read/Write | Gets or sets the box gap width. |
is_3d | `` | Read/Write | Gets or sets the is 3d. |
gap_depth | `` | Read/Write | Gets or sets the gap depth. |
view_3d | `` | Read | Gets the view 3d. |
View3D | `` | Read | PascalCase alias of view_3d. |
show_connector_lines | `` | Read/Write | Gets or sets the show connector lines. |
has_subtotals | `` | Read/Write | Gets or sets the has subtotals. |
sub_charts | `` | Read | List of sub-chart descriptors for combo charts. |
axes | `` | Read | List of ChartAxis objects defining all axes for the chart. |
scatter_style | `` | Read/Write | Gets or sets the scatter style. |
wireframe | `` | Read/Write | Whether the surface chart uses wireframe display mode (<c:wireframe val=‘1’/>). |
radar_style | `` | Read/Write | Radar chart style: ‘standard’, ‘marker’, or ‘filled’. |
histogram_bin_count | `` | Read/Write | Number of bins for count-based binning (int or None for auto/size-based). |
histogram_bin_size | `` | Read/Write | Bin width for size-based binning (float or None for auto/count-based). |
histogram_interval_closed | `` | Read/Write | Which side of each bin interval is closed: ‘r’ (right) or ’l’ (left). |
histogram_overflow | `` | Read/Write | Overflow bin boundary value (float or None). |
histogram_underflow | `` | Read/Write | Underflow bin boundary value (float or None). |
disp_blanks_as | `` | Read/Write | Gets or sets the disp blanks as. |
stock_style | `` | Read/Write | Gets or sets the stock style. |
Methods
| Signature | Description |
|---|---|
__init__(chart_type, upper_left_row, upper_left_column, lower_right_row, lower_right_column) | |
add_series(values, category_data, name, chart_type, x_values) | Convenience method to add a series. |
add_axis(axis_type, axis_id) | Adds an axis to the chart and returns it. |
copy() | Creates and returns a duplicate of the chart |
