Share via


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

Public method

ChartSheet

Infrastructure. Overloaded.

Top

Methods

 

Name

Description

Public method

_ApplyDataLabels

Infrastructure.

Public method

_Dummy23

Infrastructure.

Public method

_Evaluate

Infrastructure.

Public method

_PrintOut

Infrastructure.

Public method

_Protect

Infrastructure.

Public method

_SaveAs

Infrastructure.

Public method

Activate

Makes the current Microsoft.Office.Tools.Excel.ChartSheet the active chart.

Public method

ApplyChartTemplate

Applies a standard or custom chart template to the chart.

Public method

ApplyCustomType

Applies a standard or custom chart type to a Microsoft.Office.Tools.Excel.ChartSheet.

Public method

ApplyDataLabels

Applies data labels to a point, a series, or all the series in a Microsoft.Office.Tools.Excel.ChartSheet.

Public method

ApplyLayout

Applies the specified layout to the chart.

Public method

Arcs

Infrastructure.

Public method

AreaGroups

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).

Public method

AutoFormat

Infrastructure.

Public method

Axes

Gets an object that represents either a single axis or a collection of the axes on the chart.

Public method

BarGroups

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).

Public method

BeginInit

Infrastructure.

Public method

Buttons

Infrastructure.

Public method

ChartGroups

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).

Public method

ChartObjects

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.

Public method

ChartWizard

Modifies the properties of the given Microsoft.Office.Tools.Excel.ChartSheet.

Public method

CheckBoxes

Infrastructure.

Public method

CheckSpelling

Checks the spelling of an Microsoft.Office.Tools.Excel.ChartSheet.

Protected method

CheckValidState

(Inherited from RemoteComponent.)

Public method

ClearToMatchStyle

Clears the chart elements formatting to automatic.

Public method

ColumnGroups

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).

Public method

Copy

Copies the Microsoft.Office.Tools.Excel.ChartSheet to another location in the workbook.

Public method

CopyChartBuild

Infrastructure.

Public method

CopyPicture

Copies the Microsoft.Office.Tools.Excel.ChartSheet to the Clipboard as a picture.

Public method

CreatePublisher

Infrastructure.

Public method

Delete

Deletes the Chart object.

Public method

Deselect

Cancels the selection for the specified Microsoft.Office.Tools.Excel.ChartSheet.

Public method

Dispose

Overloaded. Releases the unmanaged resources used by the ChartSheet and optionally releases the managed resources.

Public method

DoughnutGroups

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).

Public method

DrawingObjects

Infrastructure.

Public method

Drawings

Infrastructure.

Public method

DropDowns

Infrastructure.

Public method

EndInit

Infrastructure.

Public method

Equals

Determines whether the specified Object is equal to the current Object. (Inherited from Object.)

Public method

Evaluate

Converts a Microsoft Office Excel name to an object or a value.

Public method

Export

Exports the Microsoft.Office.Tools.Excel.ChartSheet in a graphic format.

Public method

ExportAsFixedFormat

Saves the chart that is displayed on the ChartSheet in PDF or XPS format.

Protected method

Finalize

(Inherited from RemoteComponent.)

Protected method

FinishInitialization

(Inherited from EntryPointComponentBase.)

Public method

get_HasAxis

Infrastructure.

Public method

GetChartElement

Gets information about the chart element at specified X and Y coordinates.

Public method

GetHashCode

Serves as a hash function for a particular type. (Inherited from Object.)

Protected method

GetHostItem<T>

(Inherited from RemoteComponent.)

Protected method

GetObjects

Infrastructure.

Protected method

GetPrimaryControl

Infrastructure.

Protected method

GetService

(Inherited from RemoteComponent.)

Public method

GetType

Gets the type of the current instance. (Inherited from Object.)

Public method

GroupBoxes

Infrastructure.

Public method

GroupObjects

Infrastructure.

Protected method

Initialize

Infrastructure. (Overrides EntryPointComponentBase.Initialize().)

Protected method

InitializeControl

(Inherited from RemoteComponent.)

Protected method

InitializeDataBindings

(Inherited from EntryPointComponentBase.)

Public method

Labels

Infrastructure.

Public method

LineGroups

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).

Public method

Lines

Infrastructure.

Public method

ListBoxes

Infrastructure.

Public method

Location

Moves the Microsoft.Office.Tools.Excel.ChartSheet to a new location.

Protected method

MemberwiseClone

Creates a shallow copy of the current Object. (Inherited from Object.)

Public method

Move

Moves the Microsoft.Office.Tools.Excel.ChartSheet to another location in the workbook.

Public method

OLEObjects

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.

Protected method

OnBindingContextChanged

(Inherited from EntryPointBindableComponentBase.)

Protected method

OnShutdown

Infrastructure. (Overrides EntryPointComponentBase.OnShutdown().)

Protected method

OnStartup

Infrastructure. (Overrides EntryPointComponentBase.OnStartup().)

Public method

OptionButtons

Infrastructure.

Public method

Ovals

Infrastructure.

Public method

Paste

Pastes chart data from the Clipboard into the specified Microsoft.Office.Tools.Excel.ChartSheet.

Public method

Pictures

Infrastructure.

Public method

PieGroups

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).

Public method

PrintOut

Prints the Microsoft.Office.Tools.Excel.ChartSheet.

Public method

PrintOutEx

Prints the chart that is displayed on the ChartSheet.

Public method

PrintPreview

Shows a preview of the Microsoft.Office.Tools.Excel.ChartSheet as it would look when printed.

Public method

Protect

Protects a Microsoft.Office.Tools.Excel.ChartSheet so that it cannot be modified.

Public method

RadarGroups

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).

Public method

Rectangles

Infrastructure.

Public method

Refresh

Updates the cache of the Microsoft.Office.Tools.Excel.ChartSheet.

Public method

SaveAs

Saves changes to the Microsoft.Office.Tools.Excel.ChartSheet in a different file.

Public method

SaveChartTemplate

Saves the chart on the ChartSheet as a custom template in the list of available chart templates.

Public method

ScrollBars

Infrastructure.

Public method

Select

Selects the Microsoft.Office.Tools.Excel.ChartSheet.

Public method

SeriesCollection

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.

Public method

set_HasAxis

Infrastructure.

Public method

SetBackgroundPicture

Sets the background graphic for a Microsoft.Office.Tools.Excel.ChartSheet.

Public method

SetDefaultChart

Specifies the name of the chart template that Microsoft Office Excel uses when creating new charts.

Public method

SetElement

Modifies an element on the chart that is displayed on the ChartSheet.

Protected method

SetPrimaryCookie

(Inherited from RemoteComponent.)

Public method

SetSourceData

Sets the source data range for the Microsoft.Office.Tools.Excel.ChartSheet.

Public method

Spinners

Infrastructure.

Public method

TextBoxes

Infrastructure.

Public method

ToString

Returns a string that represents the current object. (Inherited from Object.)

Public method

Unprotect

Removes protection from a Microsoft.Office.Tools.Excel.ChartSheet. This method has no effect if the sheet or workbook is not protected.

Public method

XYGroups

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

Public property

_CodeName

Infrastructure.

Public property

Application

Gets an Application that represents the Microsoft Office Excel application.

Public property

Area3DGroup

Gets a ChartGroup that represents the area chart group on a 3-D Microsoft.Office.Tools.Excel.ChartSheet.

Public property

AutoScaling

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

Public property

BackWall

Gets an object that represents the back wall of a 3-D chart.

Public property

Bar3DGroup

Gets a ChartGroup that represents the bar chart group on a 3-D Microsoft.Office.Tools.Excel.ChartSheet.

Public property

BarShape

Gets or sets the shape used with the 3-D bar or column Microsoft.Office.Tools.Excel.ChartSheet.

Public property

BindingContext

(Inherited from EntryPointBindableComponentBase.)

Public property

ChartArea

Gets a ChartArea that represents the complete chart area for the Microsoft.Office.Tools.Excel.ChartSheet.

Public property

ChartStyle

Gets or sets the style of the chart.

Public property

ChartTitle

Gets a ChartTitle that represents the title of the specified Microsoft.Office.Tools.Excel.ChartSheet.

Public property

ChartType

Gets or sets the Microsoft.Office.Tools.Excel.ChartSheet type.

Public property

CodeName

Infrastructure.

Public property

Column3DGroup

Gets a ChartGroup that represents the column chart group on a 3-D Microsoft.Office.Tools.Excel.ChartSheet.

Public property

Container

(Inherited from RemoteComponent.)

Public property

ContainerComponent

(Inherited from EntryPointBindableComponentBase.)

Public property

Corners

Gets a Corners object that represents the corners of a 3-D Microsoft.Office.Tools.Excel.ChartSheet.

Public property

Creator

Gets an XlCreator code that indicates the application in which the Microsoft.Office.Tools.Excel.ChartSheet was created.

Public property

DataBindings

(Inherited from EntryPointBindableComponentBase.)

Protected property

DataHost

(Inherited from EntryPointComponentBase.)

Public property

DataTable

Gets a DataTable object that represents the Microsoft.Office.Tools.Excel.ChartSheet data table.

Public property

DefaultDataSourceUpdateMode

(Inherited from EntryPointBindableComponentBase.)

Public property

DepthPercent

Gets or sets the depth of a 3-D chart as a percentage of the Microsoft.Office.Tools.Excel.ChartSheet width.

Protected property

DesignMode

(Inherited from RemoteComponent.)

Public property

DisplayBlanksAs

Gets or sets the way that blank cells are plotted on a Microsoft.Office.Tools.Excel.ChartSheet.

Public property

Elevation

Gets or sets the elevation of the 3-D Microsoft.Office.Tools.Excel.ChartSheet, in degrees.

Public property

Floor

Gets a Floor object that represents the floor of the 3-D Microsoft.Office.Tools.Excel.ChartSheet.

Public property

GapDepth

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.

Public property

HasAxis

Gets or sets a value indicating whether a specific axis exists on the Microsoft.Office.Tools.Excel.ChartSheet.

Public property

HasDataTable

Gets or sets a value that indicates whether the Microsoft.Office.Tools.Excel.ChartSheet has a data table.

Public property

HasLegend

Gets or sets a value that indicates whether the Microsoft.Office.Tools.Excel.ChartSheet has a legend.

Public property

HasPivotFields

Gets or sets a value that indicates whether the PivotChart controls are displayed on the specified PivotChart report.

Public property

HasTitle

Gets or sets a value the indicates whether the Microsoft.Office.Tools.Excel.ChartSheet has a visible title.

Public property

HeightPercent

Gets or sets the height of a 3-D chart as a percentage of the Microsoft.Office.Tools.Excel.ChartSheet width.

Protected property

HostContext

(Inherited from RemoteComponent.)

Public property

Hyperlinks

Gets a Hyperlinks collection that represents the hyperlinks for the Microsoft.Office.Tools.Excel.ChartSheet.

Protected property

Identifier

(Inherited from RemoteComponent.)

Public property

Index

Gets the index number of the Microsoft.Office.Tools.Excel.ChartSheet.

Public property

InnerObject

Gets a Chart that represents the underlying native object for the ChartSheet.

Protected property

InnerType

(Inherited from RemoteComponent.)

Protected property

ItemProvider

(Inherited from RemoteComponent.)

Public property

Legend

Gets a Legend that represents the legend for the Microsoft.Office.Tools.Excel.ChartSheet.

Public property

Line3DGroup

Gets a ChartGroup that represents the line chart group on a 3-D Microsoft.Office.Tools.Excel.ChartSheet.

Public property

MailEnvelope

Represents an e-mail header for a document.

Public property

Name

Gets or sets the name of the Microsoft.Office.Tools.Excel.ChartSheet.

Public property

Next

Gets a Worksheet object that represents the next sheet.

Public property

OnDoubleClick

Infrastructure.

Public property

OnSheetActivate

Infrastructure.

Public property

OnSheetDeactivate

Infrastructure.

Public property

PageSetup

Gets a PageSetup that contains all the page setup settings for the Microsoft.Office.Tools.Excel.ChartSheet.

Public property

Parent

Gets the parent object for the Microsoft.Office.Tools.Excel.ChartSheet.

Public property

Perspective

Gets or sets the perspective for the 3-D Microsoft.Office.Tools.Excel.ChartSheet.

Public property

Pie3DGroup

Gets a ChartGroup that represents the pie chart group on a 3-D Microsoft.Office.Tools.Excel.ChartSheet.

Public property

PivotLayout

Gets a PivotLayout that represents the placement of fields in a PivotTable report and the placement of axes in a PivotChart report.

Public property

PlotArea

Gets a PlotArea object that represents the plot area of a Microsoft.Office.Tools.Excel.ChartSheet.

Public property

PlotBy

Gets or sets the way columns or rows are used as data series on the Microsoft.Office.Tools.Excel.ChartSheet.

Public property

PlotVisibleOnly

Gets or sets a value that indicates whether only visible cells are plotted.

Public property

Previous

Gets a Worksheet object that represents the previous sheet.

Protected property

PrimaryCookie

(Inherited from RemoteComponent.)

Public property

ProtectContents

Gets a value that indicates whether the contents of the Microsoft.Office.Tools.Excel.ChartSheet are protected.

Public property

ProtectData

Gets or sets a value that indicates whether series formulas cannot be modified by the user.

Public property

ProtectDrawingObjects

Gets a value that indicates whether shapes are protected on the Microsoft.Office.Tools.Excel.ChartSheet.

Public property

ProtectFormatting

Gets or sets a value that indicates whether Microsoft.Office.Tools.Excel.ChartSheet formatting cannot be modified by the user.

Public property

ProtectGoalSeek

Gets or sets a value that indicates whether the user cannot modify chart data points with mouse actions.

Public property

ProtectionMode

Gets or sets a value that indicates whether user-interface-only protection is turned on.

Public property

ProtectSelection

Gets or sets a value that indicates whether Microsoft.Office.Tools.Excel.ChartSheet elements cannot be selected.

Public property

RightAngleAxes

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.

Public property

Rotation

Gets or sets the rotation of the 3-D Microsoft.Office.Tools.Excel.ChartSheet.

Public property

Scripts

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.

Public property

Shapes

Gets a Shapes object that represents all the shapes on the Microsoft.Office.Tools.Excel.ChartSheet.

Public property

ShowDataLabelsOverMaximum

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.

Public property

SideWall

Gets an object that represents the side wall of a 3-D chart.

Public property

Site

(Inherited from RemoteComponent.)

Public property

SubType

Infrastructure.

Public property

SurfaceGroup

Gets a ChartGroup object that represents the surface chart group of a 3-D Microsoft.Office.Tools.Excel.ChartSheet.

Public property

Tab

Gets a Tab object for a Microsoft.Office.Tools.Excel.ChartSheet.

Public property

Tag

(Inherited from RemoteComponent.)

Public property

Type

Infrastructure.

Public property

Visible

Determines whether the object is visible.

Public property

Walls

Gets a Walls object that represents the walls of the 3-D Microsoft.Office.Tools.Excel.ChartSheet.

Public property

WallsAndGridlines2D

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

Public event

ActivateEvent

Occurs when the Microsoft.Office.Tools.Excel.ChartSheet is activated.

Public event

BeforeDoubleClick

Occurs when the Microsoft.Office.Tools.Excel.ChartSheet is double-clicked, before the default double-click action.

Public event

BeforeRightClick

Occurs when the Microsoft.Office.Tools.Excel.ChartSheet is right-clicked, before the default right-click action.

Public event

BindingContextChanged

(Inherited from EntryPointBindableComponentBase.)

Public event

Calculate

Occurs after the Microsoft.Office.Tools.Excel.ChartSheet plots new or changed data.

Public event

Deactivate

Occurs when the selection moves away from the Microsoft.Office.Tools.Excel.ChartSheet, causing the Microsoft.Office.Tools.Excel.ChartSheet to become deactivated.

Public event

Disposed

(Inherited from RemoteComponent.)

Public event

MouseDown

Occurs when a mouse button is pressed when the pointer is over a Microsoft.Office.Tools.Excel.ChartSheet.

Public event

MouseMove

Occurs when the position of the mouse pointer changes over the Microsoft.Office.Tools.Excel.ChartSheet.

Public event

MouseUp

Occurs when a mouse button is released when the pointer is over the Microsoft.Office.Tools.Excel.ChartSheet.

Public event

Resize

Occurs when the size of the Microsoft.Office.Tools.Excel.ChartSheet is changed.

Public event

SelectEvent

Occurs when the Microsoft.Office.Tools.Excel.ChartSheet is selected.

Public event

SeriesChange

Occurs when the value of a Microsoft.Office.Tools.Excel.ChartSheet data point is changed.

Public event

Shutdown

Occurs when the application domain for the assembly is about to unload.

Public event

Startup

Occurs after the document is running and all the initialization code in the assembly has been run.

Top

Explicit Interface Implementations

 

Name

Description

Explicit interface implemetationPrivate method

IEntryPoint.FinishInitialization

(Inherited from EntryPointComponentBase.)

Explicit interface implemetationPrivate method

IEntryPoint.Initialize

(Inherited from EntryPointComponentBase.)

Explicit interface implemetationPrivate method

ISupportInitializeControl.InitializeControl

Infrastructure.

Explicit interface implemetationPrivate method

IEntryPoint.InitializeDataBindings

(Inherited from EntryPointComponentBase.)

Explicit interface implemetationPrivate method

IEntryPoint.OnShutdown

(Inherited from EntryPointComponentBase.)

Top

See Also

Reference

ChartSheet Class

Microsoft.Office.Tools.Excel Namespace