ChartObjects 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.
A collection of all the ChartObject objects on the specified chart sheet, dialog sheet, or worksheet.
public interface class ChartObjects : System::Collections::IEnumerable
[System.Runtime.InteropServices.Guid("000208D0-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface ChartObjects : System.Collections.IEnumerable
Public Interface ChartObjects
Implements IEnumerable
- Attributes
- Implements
Remarks
Each ChartObject object represents an embedded chart. The ChartObject object acts as a container for a Chart object. Properties and methods for the ChartObject object control the appearance and size of the embedded chart on the sheet.
Use the ChartObjects(Object) method to return the ChartObjects collection. Use the Add(Double, Double, Double, Double) method to create a new, empty embedded chart and add it to the collection. Use the ChartWizard(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) method to add data and format the new chart.
Use ChartObjects(index
), where index
is the embedded chart index number or name, to return a single ChartObject object.
Properties
Application |
Returns an Application object that represents the Microsoft Excel application. |
Border |
Returns a Border object that represents the border of the object. |
Count |
Returns the number of objects in the collection. |
Creator |
Returns a 32-bit integer that indicates the application in which this object was created. |
Enabled |
True if the object is enabled. |
Height |
The height of the object. |
Interior |
Returns an Interior object that represents the interior of the specified object. |
Left |
The distance from the left edge of the object to the left edge of column A (on a worksheet) or the left edge of the chart area (on a chart). |
Locked |
True if the object is locked; False if the object can be modified when the sheet is protected. |
OnAction |
Reserved for internal use. |
Parent |
Returns the parent object for the specified object. |
Placement |
Returns or sets the way the object is attached to the cells below it. |
PrintObject |
True if the object will be printed when the document is printed. |
ProtectChartObject |
True if the embedded chart frame cannot be moved, resized, or deleted through the user interface. Read/write Boolean. |
RoundedCorners |
True if the embedded chart has rounded corners. |
Shadow |
True if the object has a shadow |
ShapeRange |
Returns a ShapeRange object that represents the specified object or objects. |
Top |
The distance from the top edge of the object to the top of row 1 (on a worksheet) or the top of the chart area (on a chart). |
Visible |
Determines whether the object is visible. |
Width |
The width of the object. |
Methods
_Copy() |
Reserved for internal use. |
_Default(Object) |
Reserved for internal use. |
_Dummy12() |
Reserved for internal use. |
_Dummy15() |
Reserved for internal use. |
_Dummy22() |
Reserved for internal use. |
_Dummy25() |
Reserved for internal use. |
_Dummy27() |
Reserved for internal use. |
_Dummy28() |
Reserved for internal use. |
_Dummy3() |
Reserved for internal use. |
Add(Double, Double, Double, Double) |
Creates a new embedded chart. Returns a ChartObject object. |
BringToFront() |
Brings the object to the front of the z-order. |
Copy() |
Copies the object to the Clipboard. Copies a picture of the point or series to the Clipboard. |
CopyPicture(XlPictureAppearance, XlCopyPictureFormat) |
Copies the selected object to the Clipboard as a picture. |
Cut() |
Cuts the object to the Clipboard or pastes it into a specified destination. |
Delete() |
Deletes the object. |
Duplicate() |
Duplicates the object and returns a reference to the new copy. |
GetEnumerator() | |
Group() |
Reserved for internal use. |
Item(Object) |
Returns a single object from a collection. |
Select(Object) |
Selects the object. |
SendToBack() |
Sends the object to the back of the z-order. |