Charts 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 chart sheets in the specified or active workbook. Each chart sheet is represented by a Chart object. This doesn’t include charts embedded on worksheets or dialog sheets. For information about embedded charts, see the ChartObject object.
public interface class Charts : System::Collections::IEnumerable
[System.Runtime.InteropServices.Guid("0002086D-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface Charts : System.Collections.IEnumerable
Public Interface Charts
Implements IEnumerable
- Attributes
- Implements
Remarks
Use the Charts property to return the Charts collection. Use the Add(Object, Object, Object) method to create a new chart sheet and add it to the workbook.
You can combine the Add(Object, Object, Object) method with the ChartWizard(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) method to add a new chart that contains data from a worksheet.
Use Charts(index
), where index
is the chart sheet index number or name, to return a single Chart object.
The Sheets collection contains all the sheets in the workbook (both chart sheets and worksheets). Use Sheets(index
), where index
is the sheet name or number, to return a single sheet.
Properties
_Default[Object] |
Reserved for internal use. |
Application |
Returns an Application object that represents the Microsoft Excel application. Read-only. |
Count |
Returns the number of objects in the collection. Read-only Integer. |
Creator |
Returns a 32-bit integer that indicates the application in which this object was created. If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C. Read-only XlCreator. |
HPageBreaks |
Returns an HPageBreaks collection that represents the horizontal page breaks on the sheet. Read-only. |
Item[Object] |
Returns a single object from a collection. |
Parent |
Returns the parent object for the specified object. Read-only. |
Visible |
Determines whether the object is visible. Read/write Object. |
VPageBreaks |
Returns a VPageBreaks collection that represents the vertical page breaks on the sheet. Read-only. |
Methods
_Dummy7() |
Reserved for internal use. |
_PrintOut(Object, Object, Object, Object, Object, Object, Object) |
Reserved for internal use. |
Add(Object, Object, Object) |
This object, member, or enumeration is deprecated and is not intended to be used in your code. |
Add2(Object, Object, Object, Object) |
Inserts a chart directly onto the grid. |
Copy(Object, Object) |
Copies the sheet to another location in the workbook. |
Delete() |
Deletes the object. |
GetEnumerator() | |
Move(Object, Object) |
Moves the sheet to another location in the workbook. |
PrintOut(Object, Object, Object, Object, Object, Object, Object, Object) |
Prints the object. |
PrintOut_2(Object, Object, Object, Object, Object, Object, Object, Object) |
Reserved for internal use. |
PrintPreview(Object) |
Shows a preview of the object as it would look when printed. |
Select(Object) |
Selects the object. |