ErrorBars Interface
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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. |