Chart
A chart object. The root of a hierarchical graph of component objects providing access to chart properties and methods.Properties
Member of XlChartType enumeration specifying type of this chart. If the chart has two plots, the type reported is for the first (back-most) plot. Read-only.
Integer index of chart style (1-48).
None if no explicit style has been assigned. Assigning None removes any explicit setting.True if chart has a title. Assigning True adds a title if not present. Assigning False removes existing title.ChartTitle object providing access to title properties. Accessing this property adds a chart title element if not present. Use
has_title to test non-destructively.True if the chart has a legend. Assigning True adds a legend if it doesn’t already have one. Assigning False removes existing legend.Legend object providing access to the properties of the legend for this chart.
The category axis of this chart. In XY or Bubble charts, this is the X axis. Raises
ValueError if no category axis is defined (e.g., pie chart).ValueAxis object providing access to properties of the value axis. Raises
ValueError if chart has no value axis.SeriesCollection containing all series in this chart. When the chart has multiple plots, all series for the first plot appear before those for the second.
Sequence of plots in this chart. Most charts have only a single plot. Supports
len(), iteration, slicing, and indexed access.Font object controlling text format defaults for this chart.
Methods
Replace the categories and series values in the XML and Excel worksheet for this chart.
ChartData object containing new data
ChartTitle
Provides properties for manipulating a chart title.Properties
TextFrame instance allowing read/write access to the text and its formatting. Accessing this property adds a text frame if not present. Use
has_text_frame to test non-destructively.True if this chart title has a text frame. Assigning True adds a text frame if not present. Assigning False removes any existing text frame.ChartFormat object providing access to line and fill formatting for this chart title.