ChartSheet Properties

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 Gets or sets the collection of currency managers for the IBindableComponent. (Inherited from IBindableComponent.)
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 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 Gets the collection of data-binding objects for this IBindableComponent. (Inherited from IBindableComponent.)
Public property DataHost Infrastructure.
Public property DataTable Gets a DataTable object that represents the Microsoft.Office.Tools.Excel.ChartSheet data table.
Public property DefaultExtension Gets the default extension for this ChartSheet object.
Public property DepthPercent Gets or sets the depth of a 3-D chart as a percentage of the Microsoft.Office.Tools.Excel.ChartSheet width.
Public property DisplayBlanksAs Gets or sets the way that blank cells are plotted on a Microsoft.Office.Tools.Excel.ChartSheet.
Public property Dummy24 Infrastructure.
Public property Dummy25 Infrastructure.
Public property Elevation Gets or sets the elevation of the 3-D Microsoft.Office.Tools.Excel.ChartSheet, in degrees.
Public property Extension Gets a custom extension for this ChartSheet object.
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.
Public property HostContext Infrastructure.
Public property Hyperlinks Gets a Hyperlinks collection that represents the hyperlinks for the Microsoft.Office.Tools.Excel.ChartSheet.
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.
Public property ItemProvider Infrastructure.
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.
Public property PrintedCommentPages Gets the number of comment pages that will be printed for the current chart sheet.
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 ShowAllFieldButtons Gets or sets whether to display all field buttons on a PivotChart that is displayed on the ChartSheet.
Public property ShowAxisFieldButtons Gets or sets whether to display axis field buttons on a PivotChart that is displayed on the 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 ShowLegendFieldButtons Gets or sets whether to display legend field buttons on a PivotChart that is displayed on the ChartSheet.
Public property ShowReportFilterFieldButtons Gets or sets whether to display the report filter field buttons on a PivotChart that is displayed on the ChartSheet.
Public property ShowValueFieldButtons Gets or sets whether to display the value field buttons on a PivotChart that is displayed on the ChartSheet.
Public property SideWall Gets an object that represents the side wall of a 3-D chart.
Public property Site Gets or sets the ISite associated with the IComponent. (Inherited from IComponent.)
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 Gets or sets the object that contains data about the ChartSheet.
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 Interface

Microsoft.Office.Tools.Excel Namespace