Represents a collection of adjustment values for a specified AutoShape or connector.

An IAdjustments object provides access to the adjustment points that control the geometry of a shape. The number of available adjustment points depends on the current shape type. Use Count to determine how many adjustment points are available, and use this[int] as an indexer to read an adjustment value or assign a new value. Assigning through the indexer modifies the value of the specified adjustment point.

Represents a collection of IAxis objects in a chart.

Use this interface to access the axes that belong to a chart, retrieve a specific axis by its type, and iterate through the available axes.

Represents a single axis in a chart.

An IAxis provides access to axis settings such as the axis group, title, scaling, crossing behavior, tick labels, and gridlines for category, value, and series axes.

Represents the title of a chart axis.

An IAxisTitle extends IChartTitle and provides access to the text and formatting of an axis title. Use AxisTitle to obtain the title object for a chart axis.

Represents a background picture on a worksheet or chart sheet.

An IBackgroundPicture is a shape in the IBackgroundPictures collection returned by BackgroundPictures. In addition to the members inherited from IShape, it provides background-picture-specific settings such as transparency, image layout, and corner radius.

Represents the collection of background pictures on a worksheet or chart sheet.

This interface provides access to the IBackgroundPicture objects associated with a sheet, including retrieving pictures by index or name and obtaining the total number of pictures in the collection.

Represents a chart object in a worksheet.

An IChart provides access to the chart's data series, axes, title, legend, plot area, and chart type so you can create and configure charts that are hosted by worksheet shapes.

Represents the chart area of a chart. The chart area on a 2-D chart contains the axes, the chart title, the axis titles, and the legend. The chart area
on a 3-D chart contains the chart title and the legend; it doesn’t include
the plot area (the area within the chart area where the data is plotted).
For information about the area where data is plotted and formatted, see the IPlotArea object.

Represents the up bars in a chart group.

Up bars connect the points in the first series to higher values in the last series of a line chart group. Obtain this interface from UpBars after enabling up and down bars with HasUpDownBars.

Provides access to the Office Art formatting for chart elements.

Use this interface to work with the fill, line, and 3-D formatting exposed by a chart element's format object. An instance is typically obtained from another chart API such as a chart area, series, axis, legend, or data label.

Represents one or more series plotted in a chart with the same format.

An IChartGroup is a member of the IChartGroups collection. Use this interface to access and configure group-level settings that apply to the series in the same chart group, such as axis grouping and chart-type-specific options.

Represents a collection of all IChartGroup objects in a specified IChart.

Use this interface to access the chart groups contained in a chart, including charts that contain multiple group types. An IChartGroup represents one or more series plotted with the same format.

Represents chart lines in a chart group.

This interface is used for chart-group line elements such as series lines, drop lines, and high-low lines. These lines connect related data points or series values and can be formatted through the returned IChartFormat object.

Represents the title of a chart.

An IChartTitle provides access to the title text and related formatting for a chart, including its text frame, font, layout participation, formula binding, text orientation, and text direction. Use ChartTitle to obtain the title object for a chart.

Represents the color format of a drawing object, such as a fill, pattern, line, font, or gradient stop color.

Use this interface to read or modify drawing colors exposed by APIs such as Color, PatternColor, Color, Color, and Color. An IColorFormat can describe a theme-based color, an RGB color, or a color with brightness, tint, and shade adjustments.

Represents properties and methods that apply to connectors.

Use this interface to inspect and modify connector-specific settings, such as the connector type and the shapes connected to the beginning or end of the connector. You can obtain an IConnectorFormat instance from a connector shape through ConnectorFormat.

Represents a floating container in a worksheet drawing layer.

This interface defines the common position and size members for floating objects such as shapes, charts, and pictures. It provides coordinates and dimensions in worksheet units through methods such as Top, Left, Width, and Height, and also provides pixel-based variants for the same measurements.

Objects that implement IContainer are typically obtained from drawing APIs that return related interfaces such as IShape.

Represents the cropping settings for an image.

An ICrop object defines the source image size, the image offsets, and the shape bounds used to display only part of the image. You can obtain this interface from Crop.

Represents the data label on a chart point or trendline.

Use this interface to configure the text content, position, number format, and visual formatting of a chart data label. An IDataLabel can be obtained from a chart point or from a trendline equation label. The parent returned by Parent can therefore be an IPoint or an ITrendline.

Represents a collection of all IDataLabel objects for a series.

Each IDataLabel object represents the data label for a point or trendline. For a series without definable points, such as an area series, the collection contains a single data label.

You can use this collection to configure label display settings for the entire series and to access individual data labels. entire series and to access individual data labels.

Represents a chart data table.

Represents a unit label on a chart axis.

Use this interface to access and customize the label shown for an axis display unit, including its text, font, text frame, and chart formatting. An instance is typically obtained from DisplayUnitLabel for a value axis.

Represents the error bars in a chart series.

Error bars indicate the degree of uncertainty for chart data. They can be applied to series in area, bar, column, line, and scatter groups on 2D charts. Only scatter series support both X and Y error bars.

Use this interface to configure the included error-bar parts, value type, end style, amount, custom positive and negative formulas, and chart formatting for a series.

Represents fill formatting for a shape or chart element.

Use this interface to inspect and modify fill settings such as solid color, pattern, gradient, texture, transparency, and visibility for a drawing object. Instances of this interface are typically obtained from a public formatting API such as Fill.

Represents the floor of a 3-D chart.

Use this interface to format the floor area of a 3-D chart and to control its thickness. The floor exposes an IChartFormat object for line and fill formatting and belongs to a parent IChart.

Represents font attributes, such as font name, font size, color, and text styles, for an object.

Use this interface to read or modify the formatting of text associated with drawing-related objects. It provides access to font color through IColorFormat and to common text style settings such as bold, italic, underline, strikethrough, subscript, superscript, and theme font.

Represents a single stop in a gradient.

A gradient stop defines one point in the gradient transition, including its IColorFormat color, position, and transparency. Use GradientStops to access the stops in a gradient fill and adjust each IGradientStop to refine the gradient effect.

Represents a collection of IGradientStop objects.

Use this collection to access, add, and remove the gradient stops that define a gradient fill or line. Instances of this interface are typically obtained from APIs such as GradientStops.

Represents major or minor gridlines on a chart axis.

Use this interface to access the formatting of chart axis gridlines and to navigate to the owning IAxis. Gridlines are typically obtained from MajorGridlines or MinorGridlines.

Represents the individual shapes within a grouped shape.

Use this collection to inspect or retrieve the shapes that belong to a grouped shape returned by GroupItems.

Represents the legend in a chart.

A legend identifies the data series or points plotted in a chart and can be used to control legend position, layout participation, formatting, and legend entries. Use Legend to access the legend for a chart, then customize it through members such as Font, Format, LegendEntries, Position, and Position.

Represents the collection of legend entries in a chart legend.

Use this interface to access individual ILegendEntry objects in a legend, iterate through the entries, and retrieve the legend that owns the collection. This collection is returned by LegendEntries.

Represents a legend entry in a chart legend.

An ILegendEntry identifies a single entry displayed in a chart legend. Use this interface to access the entry's font and chart formatting, or to remove the entry from the legend. Legend entries are available from the ILegendEntries collection returned by LegendEntries.

Represents line and arrowhead formatting for a shape or chart element.

This interface provides access to line appearance settings such as solid or patterned color, fill type, dash style, cap style, join style, transparency, visibility, weight, and arrowhead settings at both the beginning and end of a line. It is typically obtained from APIs such as Line.

Represents picture formatting options for a shape.

This interface provides access to picture-specific properties such as brightness, contrast, transparency, color transformation, cropping, image data, and linked picture settings. An IPictureFormat object is typically obtained from PictureFormat and applies to both regular pictures and linked pictures.

Represents the display options for PivotChart field buttons.

Use this interface to control whether report filter, legend, axis, value, and other field buttons are shown on a PivotChart. Obtain an IPivotOptions object from PivotOptions.

Represents the plot area of a chart. This is the area where your chart data is plotted.

Represents a single point in a chart series.

An IPoint instance represents an individual data point within a series and provides access to point-specific settings such as formatting, marker options, data labels, explosion for pie or doughnut slices, and other point-level chart behavior.

Represents a collection of all IPoint objects in a chart series.

An IPoints instance is typically obtained from Points. It provides indexed access to individual points in the series and supports iteration through all points.

Represents a series in a chart.

An ISeries object stores the data and formatting for a single chart series and is a member of the ISeriesCollection collection. Use this interface to access series-level settings such as the chart type, axis group, markers, data labels, error bars, and trendlines.

Represents a collection of all ISeries objects in a chart.

Use this interface to access, add, and create chart series returned by SeriesCollection.

Represents an object in the drawing layer, such as an AutoShape, chart, connector, or picture.

An IShape is a member of the IShapes collection and provides the common shape API for positioning, sizing, grouping, formatting, and accessing specialized shape features such as charts, controls, and connectors.

Represents a shape range, which is a set of shapes on a document.

Provides access to shape ranges by shape name or index arrays.

This interface is returned by Range and lets you retrieve an IShapeRange from selected shapes.

Represents a collection of all IShape objects on a worksheet.

This interface provides access to drawing objects on the specified sheet, including shapes, charts, pictures, and connectors. It supports adding new drawing objects, retrieving individual shapes by index or name, creating shape range (IShapeRange) subsets, and iterating through the collection.

Represents the text frame in an IShape object.

An ITextFrame provides access to the text content and layout settings of a shape, including the text range, text direction, text anchoring, and inner margins.

Represents the text frame in the IShape.

Represents a shape's three-dimensional formatting.

This interface provides access to 3-D effect properties such as extrusion depth, rotation, perspective, visibility, and Z position for a drawing object. You can obtain an IThreeDFormat instance from APIs such as IShape.ThreeD or IChartFormat.ThreeD.

Represents the tick-mark labels associated with a chart axis.

Use this interface to format and position axis labels, including their font, number format, text direction, text orientation, and label offset. An ITickLabels object is returned by TickLabels.

Represents a trendline in a chart.

A trendline shows the trend, or direction, of data in a series. Use this interface to configure how the trendline is calculated and displayed, such as its type, forward or backward projection, equation, and R-squared value.

Represents the collection of trend lines for a specific chart ISeries.

Use this interface to add, access, and iterate the ITrendline objects associated with a series. A trendline can be used to show the data trend for the series and can then be configured through the returned ITrendline object. series and can then be configured through the returned ITrendline object.

Represents the walls of a 3-D chart.

A wall is the plane behind or beside a 3-D chart. Use this interface to access the wall's IChartFormat and to control its thickness for walls returned by BackWall or SideWall.

Specifies the length of the arrowhead at the end of a line.

Used with BeginArrowheadLength and EndArrowheadLength to control the arrowhead size on shape or connector lines.

Specifies the style of the arrowhead at the end of a line.

Used with BeginArrowheadStyle and EndArrowheadStyle to configure the arrowhead appearance on connectors and shape lines.

Specifies the width of the arrowhead at the end of a line.

Used with BeginArrowheadWidth and EndArrowheadWidth to control the arrowhead width on shape or connector lines.

Specifies the shape type for a preset shape.

Use this enumeration to create preset shapes with a specific geometry or to change the geometry of an existing shape through AutoShapeType. It is also returned by AutoShapeType for shapes that represent preset shapes.

Specifies the point on the specified axis where the other axis crosses.

Use this enumeration with Crosses to control whether an axis crosses automatically, at the minimum or maximum value, or at a custom position defined by the axis crossing value.

Specifies the axis group used by a chart axis or series.

Use this enum with chart APIs such as series and axes to select whether data is plotted on the primary axis group or the secondary axis group.

Specifies the type of chart axis.

Use this enumeration with Axes, IAxes.Item(AxisType), or IAxes.Item(AxisType, AxisGroup) to select the category axis, value axis, or series axis in a chart.

Specifies the shape used to render 3-D bar or column charts.

Use this enumeration with BarShape or BarShape to control whether 3-D bars or columns are rendered as boxes, cylinders, cones, or pyramids.

Specifies how the horizontal axis of a histogram chart is formatted.

Use this enumeration with BinsType to control whether histogram bins are determined automatically, by category, manually, by bin size, or by bin count.

Specifies the chart category axis type.

Use this enum to control how a chart category axis groups its data, such as by discrete categories, time intervals, values, or automatic detection.

Specifies how values are split into the secondary plot of a pie-of-pie or bar-of-pie chart.

Use this enumeration with the pie chart group's SplitType property to control which data points are moved from the primary plot to the secondary plot. Depending on the selected value, the split is based on position, value, percentage, or a custom data point selection.

Specifies the chart type.

Use this enumeration to define how chart data is visualized, such as column, line, pie, scatter, radar, stock, surface, statistical, and specialized chart types.

Specifies the type of connector to create or apply to a connector shape.

Use this enum with connector APIs such as AddConnector(ConnectorType, double, double, double, double) and Type to control whether a connector is straight, elbowed, or curved.

Specifies where a chart data label is positioned.

Use this enumeration with Position or Position to control the placement of data labels for chart points or an entire series.

Specifies the display unit for a value axis.

Use this enum with DisplayUnit to scale the values shown on a chart axis and its display unit label. Use Custom together with the custom display unit settings on the axis when you need a unit value that is not represented by the built-in options.

Specifies how pictures are displayed on a column or bar picture chart.

Use this enumeration with APIs such as PictureType and PictureType to control whether a picture stretches across a bar or is repeated along it.

Specifies the end cap style for chart error bars.

Use this enum with EndStyle to control whether an error bar is drawn with a cap at its end.

Specifies the direction of error bars on a chart series.

Error bars indicate the degree of uncertainty in chart data. Only series in area, bar, column, line, and scatter chart groups on 2D charts can have error bars. Only scatter chart series can have both X and Y error bars. Use Direction to retrieve the direction of an error bar.

Specifies which error-bar parts to include.

Use this enum with Type to control whether a chart series displays positive error bars, negative error bars, both, or none.

Specifies how the range of a chart series error bar is calculated.

Use this enum with ValueType to define whether the error bar range is based on a fixed value, a percentage, standard deviation, standard error, or custom worksheet formulas.

Specifies a shape's fill type.

Use this enumeration to identify how a shape or line is filled, such as with a solid color, pattern, gradient, texture, picture, or the fill inherited from a group. This value is typically returned by APIs such as Type.

Specifies the style for a gradient fill.

Use this enum with gradient-related members such as OneColorGradient(GradientStyle, int, double), TwoColorGradient(GradientStyle, int), and PresetGradient(GradientStyle, int, PresetGradientType) to control the direction and origin of a shape's gradient effect.

Specifies the horizontal anchor for the text frame in a shape.

Use this enum with HorizontalAnchor to control how a shape's text frame is positioned horizontally within the shape. To control the horizontal alignment of the text itself, use TextAlignment instead.

Specifies how a background image is positioned, scaled, or tiled within its destination rectangle.

Use this enum with BackgroundImageLayout to control whether the image keeps its aspect ratio, stretches to fill the bounds, fills with clipping, centers within the destination rectangle, or tiles across it.

Specifies the image format used by APIs that import, fill, or export images.

Use this enum to indicate the format of image data when working with drawing-related APIs, such as adding a picture from a stream or exporting a shape as an image.

Specifies the position of the legend on a chart.

Use this enumeration with Position to place the legend above, below, to the left of, or to the right of the chart, or to use a custom legend position.

Specifies the cap type for a line.

Use this enum with CapStyle to control how the end of a shape line is rendered, such as flat, square, or rounded.

Specifies the dash style for a line.

Use this enumeration with DashStyle to control how a shape or connector line is rendered, such as solid, dotted, or dashed patterns.

Specifies the corner style applied where two lines intersect.

Use this enumeration with JoinStyle to control how shape or connector line corners are rendered.

Specifies the style for a line.

Use this enum with ILineFormat to apply a predefined compound line style to a shape line, such as a single line, two thin lines, or a thick line combined with thin lines.

Specifies the marker style for a point or series in a line chart, scatter chart, or radar chart.

Specifies the parent data label option for a series within a chart group.

Use this enumeration with ParentDataLabelOption to control how parent data labels are displayed for the series.

Specifies the path type for a shape gradient fill.

Use this enum with GradientPathType to control how a gradient is applied to a shape. Supported gradient fill path types include linear, radial, rectangular, and path-based gradients.

Specifies the pattern used for a shape fill or patterned line.

Use this enum with Patterned(PatternType) or Patterned(PatternType) to apply percentage-based fills, directional lines, grids, diamonds, bricks, and other built-in drawing patterns. Many values combine the foreground and background colors of the target fill or line format.

Specifies the color transformation applied to a picture.

Use this enum with ColorType to apply a predefined picture effect such as grayscale, black-and-white, or watermark.

Specifies how an object is attached to its underlying cells.

Use this enum to control whether a shape or control moves with cells, resizes with cells, or remains free floating when the worksheet layout changes.

Represents preset 3-D camera angle values for use by document models that support these values.

Use this enum to identify a predefined camera angle, such as legacy oblique, perspective, orthographic, or isometric angles.

Specifies which predefined gradient to use when applying a preset gradient to a fill or line.

Use this enum with PresetGradient(GradientStyle, int, PresetGradientType) or PresetGradient(GradientStyle, int, PresetGradientType) to apply one of the built-in gradient presets, such as EarlySunset, Horizon, or Nightfall.

Specifies a preset texture that can be applied to a shape fill.

Use this enum with PresetTextured(PresetTexture) to apply a built-in texture, or with PresetTexture to read the currently configured preset texture.

Specifies a preset extrusion (three-dimensional) format.

Use this enumeration to identify one of the built-in 3-D format presets when working with shape or chart three-dimensional formatting.

Specifies whether the values corresponding to a particular data series are in rows or columns.

Used when adding data series to a chart's ISeriesCollection to indicate the orientation of the source data range.

Specifies the scale type for a chart value axis.

Use this enum with ScaleType to control whether the value axis uses linear or logarithmic scaling. When Logarithmic is used, you can configure the logarithmic base through LogBase.

Specifies the general category of a drawing object.

Use this enumeration with Type to determine whether a shape represents an AutoShape, chart, comment, picture, group, or another supported drawing object type.

Specifies what bubble size represents in a bubble chart.

Use this enum with SizeRepresents to control whether bubble sizes are interpreted by area or by width.

Specifies the type of solid color used by an IColorFormat.

Use this enum with ColorType to indicate whether a drawing color has no color, uses the automatic color, uses an explicit RGB color, or uses a theme color.

Specifies the horizontal alignment for text within the text frame of a shape.

Use this enum with TextAlignment to control how text is aligned inside a shape's text range.

Specifies the text direction for text in a shape's text frame.

Used with Direction to control how text is oriented within a shape, including horizontal, vertical, rotated, and stacked layouts.

Specifies the type of an ITextRange.

An ITextRange has a hierarchical structure: Body contains Paragraphs, and each Paragraph contains Runs. Use Type to determine the type of a given text range.

Specifies the underline style for drawing text.

Use this enumeration with Underline to control how text is underlined in drawing objects such as chart text and data tables. The available values include no underline, word-only underline, single and double underlines, and several decorative underline patterns.

Specifies the alignment, which is the origin of the coordinate grid, for tiling a texture fill.

Use this enum with TextureAlignment to control how a texture is aligned within a filled shape, or with TextureAlignment to read the current texture alignment.

Represents texture fill type enumeration values.

Currently, texture fills are typically created by using PresetTextured(PresetTexture) or UserTextured(string).

Specifies the text orientation for tick-mark labels.

This enum defines whether text is displayed upward, downward, vertically, horizontally, or with the orientation determined by Excel. It is used by APIs such as Orientation to control the displayed text direction.

Specifies the position of tick-mark labels on a chart axis.

Use this enum with TickLabelPosition to control where axis labels are displayed, such as at the low side, high side, next to the axis, or hidden.

Specifies the position of major and minor tick marks on a chart axis.

Use this enum with axis APIs such as MajorTickMark and MinorTickMark to control whether tick marks are drawn inside the axis, outside the axis, across the axis, or not shown.

Specifies the unit of time for a chart axis or data series.

Use this enum with date-based category axis settings such as BaseUnit, MajorUnitScale, and MinorUnitScale to control whether the axis is measured in days, months, or years.

Specifies how a chart trendline is calculated.

Use this enum with Type to choose the mathematical model used to fit a trendline to a data series, such as linear, logarithmic, polynomial, power, exponential, or moving-average analysis.

Specifies the vertical alignment of text within a shape's text frame.

Use this enum with VerticalAnchor to position text at the top, middle, or bottom of the text frame.

Specifies where a shape should be moved in the z-order relative to other shapes.

Use this enum with ZOrder(ZOrderType) to bring a shape forward, send it backward, move it to the front, or move it to the back of the shape collection.