編輯

共用方式為


ErrorBars Interface

Definition

Represents the error bars on a chart series.

public interface class ErrorBars
[System.Runtime.InteropServices.Guid("194F8476-B79D-4572-A609-294207DE77C1")]
public interface ErrorBars
type ErrorBars = interface
Public Interface ErrorBars
Attributes

Examples

Use the ErrorBars property to return the ErrorBars object. The following example turns on error bars for series one of the first chart in the active document and then sets the end style for the error bars.

Remarks

Error bars indicate the degree of uncertainty for chart data. Only series in area, bar, column, line, and scatter groups on a 2-D chart can have error bars. Only series in scatter groups can have x and y error bars. This object isn’t a collection. There’s no object that represents a single error bar; you either have x error bars or y error bars turned on for all points in a series or you have them turned off.

The ErrorBar(XlErrorBarDirection, XlErrorBarInclude, XlErrorBarType, Object, Object) method changes the error bar format and type.

Properties

Application

When used without an object qualifier, this property returns an _Application object that represents the Microsoft Word application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.

Border

Returns a ChartBorder object that represents the border of the object. Read-only.

Creator

Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Integer.

EndStyle

Returns or sets the end style for the error bars. Can be one of the following XlEndStyleCap constants: xlCap or xlNoCap. Read/write

Format

Returns the line, fill, and effect formatting for the object. Read-only ChartFormat.

Name

Returns a String value that represents the name of the object.

Parent

Returns the parent for the specified object. Read-only Object.

Methods

ClearFormats()

Clears the formatting of the object.

Delete()

Deletes the object.

Select()

Selects the object.

Applies to