ChartSheet Members (2007 System)
Include Protected Members
Include Inherited Members
A ChartSheet host item is a worksheet in Excel that contains only a chart and exposes events.
The ChartSheet type exposes the following members.
Constructors
Name
Description
.gif "Public method")
Infrastructure. Overloaded.
Top
Methods
Name
Description
Infrastructure.
Infrastructure.
Infrastructure.
Infrastructure.
Infrastructure.
Infrastructure.
Makes the current Microsoft.Office.Tools.Excel.ChartSheet the active chart.
Applies a standard or custom chart template to the chart.
Applies a standard or custom chart type to a Microsoft.Office.Tools.Excel.ChartSheet.
Applies data labels to a point, a series, or all the series in a Microsoft.Office.Tools.Excel.ChartSheet.
Applies the specified layout to the chart.
Infrastructure.
On a 2-D chart, returns an object that represents either a single area chart group (a ChartGroup object) or a collection of the area chart groups (a ChartGroups collection).
Infrastructure.
Gets an object that represents either a single axis or a collection of the axes on the chart.
On a 2-D chart, returns an object that represents either a single bar chart group (a ChartGroup object) or a collection of the bar chart groups (a ChartGroups collection).
Infrastructure.
Infrastructure.
Gets an object that represents either a single chart group (a ChartGroup object) or a collection of all the chart groups in the chart (a ChartGroups object).
Gets an object that represents either a single embedded chart (a ChartObject object) or a collection of all the embedded charts (a ChartObjects object) on the sheet.
Modifies the properties of the given Microsoft.Office.Tools.Excel.ChartSheet.
Infrastructure.
Checks the spelling of an Microsoft.Office.Tools.Excel.ChartSheet.
.gif "Protected method")
(Inherited from RemoteComponent.)
Clears the chart elements formatting to automatic.
On a 2-D chart, returns an object that represents either a single column chart group (a ChartGroup object) or a collection of the column chart groups (a ChartGroups collection).
Copies the Microsoft.Office.Tools.Excel.ChartSheet to another location in the workbook.
Infrastructure.
Copies the Microsoft.Office.Tools.Excel.ChartSheet to the Clipboard as a picture.
Infrastructure.
Deletes the Chart object.
Cancels the selection for the specified Microsoft.Office.Tools.Excel.ChartSheet.
Overloaded. Releases the unmanaged resources used by the ChartSheet and optionally releases the managed resources.
On a 2-D Microsoft.Office.Tools.Excel.ChartSheet, returns an object that represents either a single doughnut chart group (a ChartGroup object) or a collection of the doughnut chart groups (a ChartGroups collection).
Infrastructure.
Infrastructure.
Infrastructure.
Infrastructure.
Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
Converts a Microsoft Office Excel name to an object or a value.
Exports the Microsoft.Office.Tools.Excel.ChartSheet in a graphic format.
Saves the chart that is displayed on the ChartSheet in PDF or XPS format.
(Inherited from RemoteComponent.)
(Inherited from EntryPointComponentBase.)
Infrastructure.
Gets information about the chart element at specified X and Y coordinates.
Serves as a hash function for a particular type. (Inherited from Object.)
(Inherited from RemoteComponent.)
Infrastructure.
Infrastructure.
(Inherited from RemoteComponent.)
Gets the type of the current instance. (Inherited from Object.)
Infrastructure.
Infrastructure.
Infrastructure. (Overrides EntryPointComponentBase.Initialize().)
(Inherited from RemoteComponent.)
(Inherited from EntryPointComponentBase.)
Infrastructure.
On a 2-D chart, returns an object that represents either a single line chart group (a ChartGroup object) or a collection of the line chart groups (a ChartGroups collection).
Infrastructure.
Infrastructure.
Moves the Microsoft.Office.Tools.Excel.ChartSheet to a new location.
Creates a shallow copy of the current Object. (Inherited from Object.)
Moves the Microsoft.Office.Tools.Excel.ChartSheet to another location in the workbook.
Gets an object that represents either a single OLE object (an OLEObject) or a collection of all OLE objects (an OLEObjects collection) on the chart or sheet.
(Inherited from EntryPointBindableComponentBase.)
Infrastructure. (Overrides EntryPointComponentBase.OnShutdown().)
Infrastructure. (Overrides EntryPointComponentBase.OnStartup().)
Infrastructure.
Infrastructure.
Pastes chart data from the Clipboard into the specified Microsoft.Office.Tools.Excel.ChartSheet.
Infrastructure.
On a 2-D Microsoft.Office.Tools.Excel.ChartSheet, returns an object that represents either a single pie chart group (a ChartGroup object) or a collection of the pie chart groups (a ChartGroups collection).
Prints the Microsoft.Office.Tools.Excel.ChartSheet.
Prints the chart that is displayed on the ChartSheet.
Shows a preview of the Microsoft.Office.Tools.Excel.ChartSheet as it would look when printed.
Protects a Microsoft.Office.Tools.Excel.ChartSheet so that it cannot be modified.
On a 2-D Microsoft.Office.Tools.Excel.ChartSheet, returns an object that represents either a single radar chart group (a ChartGroup object) or a collection of the radar chart groups (a ChartGroups collection).
Infrastructure.
Updates the cache of the Microsoft.Office.Tools.Excel.ChartSheet.
Saves changes to the Microsoft.Office.Tools.Excel.ChartSheet in a different file.
Saves the chart on the ChartSheet as a custom template in the list of available chart templates.
Infrastructure.
Selects the Microsoft.Office.Tools.Excel.ChartSheet.
Gets an object that represents either a single series (a Series object) or a collection of all the series (a SeriesCollection collection) in the chart or chart group.
Infrastructure.
Sets the background graphic for a Microsoft.Office.Tools.Excel.ChartSheet.
Specifies the name of the chart template that Microsoft Office Excel uses when creating new charts.
Modifies an element on the chart that is displayed on the ChartSheet.
(Inherited from RemoteComponent.)
Sets the source data range for the Microsoft.Office.Tools.Excel.ChartSheet.
Infrastructure.
Infrastructure.
Returns a string that represents the current object. (Inherited from Object.)
Removes protection from a Microsoft.Office.Tools.Excel.ChartSheet. This method has no effect if the sheet or workbook is not protected.
On a 2-D Microsoft.Office.Tools.Excel.ChartSheet, returns an object that represents either a single scatter chart group (a ChartGroup object) or a collection of the scatter chart groups (a ChartGroups collection).
Top
Properties
Name
Description
.gif "Public property")
Infrastructure.
Gets an Application that represents the Microsoft Office Excel application.
Gets a ChartGroup that represents the area chart group on a 3-D Microsoft.Office.Tools.Excel.ChartSheet.
Gets a value that indicates whether Microsoft Office Excel scales a 3-D Microsoft.Office.Tools.Excel.ChartSheet so that it is closer in size to the equivalent 2-D chart
Gets an object that represents the back wall of a 3-D chart.
Gets a ChartGroup that represents the bar chart group on a 3-D Microsoft.Office.Tools.Excel.ChartSheet.
Gets or sets the shape used with the 3-D bar or column Microsoft.Office.Tools.Excel.ChartSheet.
(Inherited from EntryPointBindableComponentBase.)
Gets a ChartArea that represents the complete chart area for the Microsoft.Office.Tools.Excel.ChartSheet.
Gets or sets the style of the chart.
Gets a ChartTitle that represents the title of the specified Microsoft.Office.Tools.Excel.ChartSheet.
Gets or sets the Microsoft.Office.Tools.Excel.ChartSheet type.
Infrastructure.
Gets a ChartGroup that represents the column chart group on a 3-D Microsoft.Office.Tools.Excel.ChartSheet.
(Inherited from RemoteComponent.)
(Inherited from EntryPointBindableComponentBase.)
Gets a Corners object that represents the corners of a 3-D Microsoft.Office.Tools.Excel.ChartSheet.
Gets an XlCreator code that indicates the application in which the Microsoft.Office.Tools.Excel.ChartSheet was created.
(Inherited from EntryPointBindableComponentBase.)
.gif "Protected property")
(Inherited from EntryPointComponentBase.)
Gets a DataTable object that represents the Microsoft.Office.Tools.Excel.ChartSheet data table.
(Inherited from EntryPointBindableComponentBase.)
Gets or sets the depth of a 3-D chart as a percentage of the Microsoft.Office.Tools.Excel.ChartSheet width.
(Inherited from RemoteComponent.)
Gets or sets the way that blank cells are plotted on a Microsoft.Office.Tools.Excel.ChartSheet.
Gets or sets the elevation of the 3-D Microsoft.Office.Tools.Excel.ChartSheet, in degrees.
Gets a Floor object that represents the floor of the 3-D Microsoft.Office.Tools.Excel.ChartSheet.
Gets or sets the distance between the data series in a 3-D Microsoft.Office.Tools.Excel.ChartSheet, as a percentage of the marker width.
Gets or sets a value indicating whether a specific axis exists on the Microsoft.Office.Tools.Excel.ChartSheet.
Gets or sets a value that indicates whether the Microsoft.Office.Tools.Excel.ChartSheet has a data table.
Gets or sets a value that indicates whether the Microsoft.Office.Tools.Excel.ChartSheet has a legend.
Gets or sets a value that indicates whether the PivotChart controls are displayed on the specified PivotChart report.
Gets or sets a value the indicates whether the Microsoft.Office.Tools.Excel.ChartSheet has a visible title.
Gets or sets the height of a 3-D chart as a percentage of the Microsoft.Office.Tools.Excel.ChartSheet width.
(Inherited from RemoteComponent.)
Gets a Hyperlinks collection that represents the hyperlinks for the Microsoft.Office.Tools.Excel.ChartSheet.
(Inherited from RemoteComponent.)
Gets the index number of the Microsoft.Office.Tools.Excel.ChartSheet.
Gets a Chart that represents the underlying native object for the ChartSheet.
(Inherited from RemoteComponent.)
(Inherited from RemoteComponent.)
Gets a Legend that represents the legend for the Microsoft.Office.Tools.Excel.ChartSheet.
Gets a ChartGroup that represents the line chart group on a 3-D Microsoft.Office.Tools.Excel.ChartSheet.
Represents an e-mail header for a document.
Gets or sets the name of the Microsoft.Office.Tools.Excel.ChartSheet.
Gets a Worksheet object that represents the next sheet.
Infrastructure.
Infrastructure.
Infrastructure.
Gets a PageSetup that contains all the page setup settings for the Microsoft.Office.Tools.Excel.ChartSheet.
Gets the parent object for the Microsoft.Office.Tools.Excel.ChartSheet.
Gets or sets the perspective for the 3-D Microsoft.Office.Tools.Excel.ChartSheet.
Gets a ChartGroup that represents the pie chart group on a 3-D Microsoft.Office.Tools.Excel.ChartSheet.
Gets a PivotLayout that represents the placement of fields in a PivotTable report and the placement of axes in a PivotChart report.
Gets a PlotArea object that represents the plot area of a Microsoft.Office.Tools.Excel.ChartSheet.
Gets or sets the way columns or rows are used as data series on the Microsoft.Office.Tools.Excel.ChartSheet.
Gets or sets a value that indicates whether only visible cells are plotted.
Gets a Worksheet object that represents the previous sheet.
(Inherited from RemoteComponent.)
Gets a value that indicates whether the contents of the Microsoft.Office.Tools.Excel.ChartSheet are protected.
Gets or sets a value that indicates whether series formulas cannot be modified by the user.
Gets a value that indicates whether shapes are protected on the Microsoft.Office.Tools.Excel.ChartSheet.
Gets or sets a value that indicates whether Microsoft.Office.Tools.Excel.ChartSheet formatting cannot be modified by the user.
Gets or sets a value that indicates whether the user cannot modify chart data points with mouse actions.
Gets or sets a value that indicates whether user-interface-only protection is turned on.
Gets or sets a value that indicates whether Microsoft.Office.Tools.Excel.ChartSheet elements cannot be selected.
Gets or sets a value that indicates whether the Microsoft.Office.Tools.Excel.ChartSheet axes are at right angles, independent of chart rotation or elevation.
Gets or sets the rotation of the 3-D Microsoft.Office.Tools.Excel.ChartSheet.
Gets the Scripts collection, which contains Script objects representing blocks of script or code in the specified document when it is saved as a Web page.
Gets a Shapes object that represents all the shapes on the Microsoft.Office.Tools.Excel.ChartSheet.
Gets or sets a value that indicates whether to show the data labels when the value is greater than the maximum value on the value axis.
Gets an object that represents the side wall of a 3-D chart.
(Inherited from RemoteComponent.)
Infrastructure.
Gets a ChartGroup object that represents the surface chart group of a 3-D Microsoft.Office.Tools.Excel.ChartSheet.
Gets a Tab object for a Microsoft.Office.Tools.Excel.ChartSheet.
(Inherited from RemoteComponent.)
Infrastructure.
Determines whether the object is visible.
Gets a Walls object that represents the walls of the 3-D Microsoft.Office.Tools.Excel.ChartSheet.
Gets or sets a value that indicates whether gridlines are drawn two-dimensionally on a 3-D Microsoft.Office.Tools.Excel.ChartSheet.
Top
Events
Name
Description
.gif "Public event")
Occurs when the Microsoft.Office.Tools.Excel.ChartSheet is activated.
Occurs when the Microsoft.Office.Tools.Excel.ChartSheet is double-clicked, before the default double-click action.
Occurs when the Microsoft.Office.Tools.Excel.ChartSheet is right-clicked, before the default right-click action.
(Inherited from EntryPointBindableComponentBase.)
Occurs after the Microsoft.Office.Tools.Excel.ChartSheet plots new or changed data.
Occurs when the selection moves away from the Microsoft.Office.Tools.Excel.ChartSheet, causing the Microsoft.Office.Tools.Excel.ChartSheet to become deactivated.
(Inherited from RemoteComponent.)
Occurs when a mouse button is pressed when the pointer is over a Microsoft.Office.Tools.Excel.ChartSheet.
Occurs when the position of the mouse pointer changes over the Microsoft.Office.Tools.Excel.ChartSheet.
Occurs when a mouse button is released when the pointer is over the Microsoft.Office.Tools.Excel.ChartSheet.
Occurs when the size of the Microsoft.Office.Tools.Excel.ChartSheet is changed.
Occurs when the Microsoft.Office.Tools.Excel.ChartSheet is selected.
Occurs when the value of a Microsoft.Office.Tools.Excel.ChartSheet data point is changed.
Occurs when the application domain for the assembly is about to unload.
Occurs after the document is running and all the initialization code in the assembly has been run.
Top
Explicit Interface Implementations
Name
Description
.gif "Explicit interface implemetation")
.gif "Private method")
IEntryPoint.FinishInitialization
(Inherited from EntryPointComponentBase.)
(Inherited from EntryPointComponentBase.)
ISupportInitializeControl.InitializeControl
Infrastructure.
IEntryPoint.InitializeDataBindings
(Inherited from EntryPointComponentBase.)
(Inherited from EntryPointComponentBase.)
Top