ChartSheet Properties (2007 System)

Include Protected Members
Include Inherited Members

The ChartSheet type exposes the following members.

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

See Also

Reference

ChartSheet Class

Microsoft.Office.Tools.Excel Namespace