ChartSheet Interface

Represents a worksheet in document-level Excel projects created by using the Office development tools in Visual Studio.

Namespace:  Microsoft.Office.Tools.Excel
Assemblies:   Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

[GuidAttribute("0bc69504-5797-4291-8178-cef15cc18b98")]
public interface ChartSheet : IBindableComponent, 
	IComponent, IDisposable, ISupportInitialize

The ChartSheet type exposes the following members.

  NameDescription
Public property_CodeNameInfrastructure.
Public propertyApplicationGets an Application that represents the Microsoft Office Excel application.
Public propertyArea3DGroupGets a ChartGroup that represents the area chart group on a 3-D Microsoft.Office.Tools.Excel.ChartSheet.
Public propertyAutoScalingGets 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 propertyBackWallGets an object that represents the back wall of a 3-D chart.
Public propertyBar3DGroupGets a ChartGroup that represents the bar chart group on a 3-D Microsoft.Office.Tools.Excel.ChartSheet.
Public propertyBarShapeGets or sets the shape used with the 3-D bar or column Microsoft.Office.Tools.Excel.ChartSheet.
Public propertyBindingContextGets or sets the collection of currency managers for the IBindableComponent. (Inherited from IBindableComponent.)
Public propertyChartAreaGets a ChartArea that represents the complete chart area for the Microsoft.Office.Tools.Excel.ChartSheet.
Public propertyChartStyleGets or sets the style of the chart.
Public propertyChartTitleGets a ChartTitle that represents the title of the specified Microsoft.Office.Tools.Excel.ChartSheet.
Public propertyChartTypeGets or sets the Microsoft.Office.Tools.Excel.ChartSheet type.
Public propertyCodeNameInfrastructure.
Public propertyColumn3DGroupGets a ChartGroup that represents the column chart group on a 3-D Microsoft.Office.Tools.Excel.ChartSheet.
Public propertyCornersGets a Corners object that represents the corners of a 3-D Microsoft.Office.Tools.Excel.ChartSheet.
Public propertyCreatorGets an XlCreator code that indicates the application in which the Microsoft.Office.Tools.Excel.ChartSheet was created.
Public propertyDataBindingsGets the collection of data-binding objects for this IBindableComponent. (Inherited from IBindableComponent.)
Public propertyDataHostInfrastructure.
Public propertyDataTableGets a DataTable object that represents the Microsoft.Office.Tools.Excel.ChartSheet data table.
Public propertyDefaultExtensionGets the default extension for this ChartSheet object.
Public propertyDepthPercentGets or sets the depth of a 3-D chart as a percentage of the Microsoft.Office.Tools.Excel.ChartSheet width.
Public propertyDisplayBlanksAsGets or sets the way that blank cells are plotted on a Microsoft.Office.Tools.Excel.ChartSheet.
Public propertyDummy24Infrastructure.
Public propertyDummy25Infrastructure.
Public propertyElevationGets or sets the elevation of the 3-D Microsoft.Office.Tools.Excel.ChartSheet, in degrees.
Public propertyExtensionGets a custom extension for this ChartSheet object.
Public propertyFloorGets a Floor object that represents the floor of the 3-D Microsoft.Office.Tools.Excel.ChartSheet.
Public propertyGapDepthGets 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 propertyHasAxisGets or sets a value indicating whether a specific axis exists on the Microsoft.Office.Tools.Excel.ChartSheet.
Public propertyHasDataTableGets or sets a value that indicates whether the Microsoft.Office.Tools.Excel.ChartSheet has a data table.
Public propertyHasLegendGets or sets a value that indicates whether the Microsoft.Office.Tools.Excel.ChartSheet has a legend.
Public propertyHasPivotFieldsGets or sets a value that indicates whether the PivotChart controls are displayed on the specified PivotChart report.
Public propertyHasTitleGets or sets a value the indicates whether the Microsoft.Office.Tools.Excel.ChartSheet has a visible title.
Public propertyHeightPercentGets or sets the height of a 3-D chart as a percentage of the Microsoft.Office.Tools.Excel.ChartSheet width.
Public propertyHostContextInfrastructure.
Public propertyHyperlinksGets a Hyperlinks collection that represents the hyperlinks for the Microsoft.Office.Tools.Excel.ChartSheet.
Public propertyIndexGets the index number of the Microsoft.Office.Tools.Excel.ChartSheet.
Public propertyInnerObjectGets a Microsoft.Office.Interop.Excel.Chart that represents the underlying native object for the ChartSheet.
Public propertyItemProviderInfrastructure.
Public propertyLegendGets a Legend that represents the legend for the Microsoft.Office.Tools.Excel.ChartSheet.
Public propertyLine3DGroupGets a ChartGroup that represents the line chart group on a 3-D Microsoft.Office.Tools.Excel.ChartSheet.
Public propertyMailEnvelopeRepresents an e-mail header for a document.
Public propertyNameGets or sets the name of the Microsoft.Office.Tools.Excel.ChartSheet.
Public propertyNextGets a Microsoft.Office.Interop.Excel.Worksheet object that represents the next sheet.
Public propertyOnDoubleClickInfrastructure.
Public propertyOnSheetActivateInfrastructure.
Public propertyOnSheetDeactivateInfrastructure.
Public propertyPageSetupGets a PageSetup that contains all the page setup settings for the Microsoft.Office.Tools.Excel.ChartSheet.
Public propertyParentGets the parent object for the Microsoft.Office.Tools.Excel.ChartSheet.
Public propertyPerspectiveGets or sets the perspective for the 3-D Microsoft.Office.Tools.Excel.ChartSheet.
Public propertyPie3DGroupGets a ChartGroup that represents the pie chart group on a 3-D Microsoft.Office.Tools.Excel.ChartSheet.
Public propertyPivotLayoutGets a PivotLayout that represents the placement of fields in a PivotTable report and the placement of axes in a PivotChart report.
Public propertyPlotAreaGets a PlotArea object that represents the plot area of a Microsoft.Office.Tools.Excel.ChartSheet.
Public propertyPlotByGets or sets the way columns or rows are used as data series on the Microsoft.Office.Tools.Excel.ChartSheet.
Public propertyPlotVisibleOnlyGets or sets a value that indicates whether only visible cells are plotted.
Public propertyPreviousGets a Microsoft.Office.Interop.Excel.Worksheet object that represents the previous sheet.
Public propertyPrintedCommentPagesGets the number of comment pages that will be printed for the current chart sheet.
Public propertyProtectContentsGets a value that indicates whether the contents of the Microsoft.Office.Tools.Excel.ChartSheet are protected.
Public propertyProtectDataGets or sets a value that indicates whether series formulas cannot be modified by the user.
Public propertyProtectDrawingObjectsGets a value that indicates whether shapes are protected on the Microsoft.Office.Tools.Excel.ChartSheet.
Public propertyProtectFormattingGets or sets a value that indicates whether Microsoft.Office.Tools.Excel.ChartSheet formatting cannot be modified by the user.
Public propertyProtectGoalSeekGets or sets a value that indicates whether the user cannot modify chart data points with mouse actions.
Public propertyProtectionModeGets or sets a value that indicates whether user-interface-only protection is turned on.
Public propertyProtectSelectionGets or sets a value that indicates whether Microsoft.Office.Tools.Excel.ChartSheet elements cannot be selected.
Public propertyRightAngleAxesGets 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 propertyRotationGets or sets the rotation of the 3-D Microsoft.Office.Tools.Excel.ChartSheet.
Public propertyScriptsGets 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 propertyShapesGets a Shapes object that represents all the shapes on the Microsoft.Office.Tools.Excel.ChartSheet.
Public propertyShowAllFieldButtonsGets or sets whether to display all field buttons on a PivotChart that is displayed on the ChartSheet.
Public propertyShowAxisFieldButtonsGets or sets whether to display axis field buttons on a PivotChart that is displayed on the ChartSheet.
Public propertyShowDataLabelsOverMaximumGets 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 propertyShowLegendFieldButtonsGets or sets whether to display legend field buttons on a PivotChart that is displayed on the ChartSheet.
Public propertyShowReportFilterFieldButtonsGets or sets whether to display the report filter field buttons on a PivotChart that is displayed on the ChartSheet.
Public propertyShowValueFieldButtonsGets or sets whether to display the value field buttons on a PivotChart that is displayed on the ChartSheet.
Public propertySideWallGets an object that represents the side wall of a 3-D chart.
Public propertySiteGets or sets the ISite associated with the IComponent. (Inherited from IComponent.)
Public propertySubTypeInfrastructure.
Public propertySurfaceGroupGets a ChartGroup object that represents the surface chart group of a 3-D Microsoft.Office.Tools.Excel.ChartSheet.
Public propertyTabGets a Tab object for a Microsoft.Office.Tools.Excel.ChartSheet.
Public propertyTagGets or sets the object that contains data about the ChartSheet.
Public propertyTypeInfrastructure.
Public propertyVisibleDetermines whether the object is visible.
Public propertyWallsGets a Walls object that represents the walls of the 3-D Microsoft.Office.Tools.Excel.ChartSheet.
Public propertyWallsAndGridlines2DGets or sets a value that indicates whether gridlines are drawn two-dimensionally on a 3-D Microsoft.Office.Tools.Excel.ChartSheet.
Top

  NameDescription
Public method_ApplyDataLabelsInfrastructure.
Public method_Dummy23Infrastructure.
Public method_EvaluateInfrastructure.
Public method_PrintOutInfrastructure.
Public method_ProtectInfrastructure.
Public method_SaveAsInfrastructure.
Public method_VtblGap1_1Infrastructure.
Public method_VtblGap2_1Infrastructure.
Public method_VtblGap3_1Infrastructure.
Public method_VtblGap4_2Infrastructure.
Public method_VtblGap5_1Infrastructure.
Public method_VtblGap6_1Infrastructure.
Public methodActivateMakes the current Microsoft.Office.Tools.Excel.ChartSheet the active chart.
Public methodApplyChartTemplateApplies a standard or custom chart template to the chart.
Public methodApplyCustomTypeApplies a standard or custom chart type to a Microsoft.Office.Tools.Excel.ChartSheet.
Public methodApplyDataLabelsApplies data labels to a point, a series, or all the series in a Microsoft.Office.Tools.Excel.ChartSheet.
Public methodApplyLayoutApplies the specified layout to the chart.
Public methodArcsInfrastructure.
Public methodAreaGroupsOn 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 methodAutoFormatInfrastructure.
Public methodAxesGets an object that represents either a single axis or a collection of the axes on the chart.
Public methodBarGroupsOn 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 methodBeginInitSignals the object that initialization is starting. (Inherited from ISupportInitialize.)
Public methodButtonsInfrastructure.
Public methodChartGroupsGets 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 methodChartObjectsGets 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 methodChartWizardModifies the properties of the given Microsoft.Office.Tools.Excel.ChartSheet.
Public methodCheckBoxesInfrastructure.
Public methodCheckSpellingChecks the spelling of an Microsoft.Office.Tools.Excel.ChartSheet.
Public methodClearToMatchStyleClears the chart elements formatting to automatic.
Public methodColumnGroupsOn 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 methodCopyCopies the Microsoft.Office.Tools.Excel.ChartSheet to another location in the workbook.
Public methodCopyChartBuildInfrastructure.
Public methodCopyPictureCopies the Microsoft.Office.Tools.Excel.ChartSheet to the Clipboard as a picture.
Public methodCreatePublisherInfrastructure.
Public methodDeleteDeletes the Microsoft.Office.Interop.Excel.Chart object.
Public methodDeselectCancels the selection for the specified Microsoft.Office.Tools.Excel.ChartSheet.
Public methodDisposePerforms application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. (Inherited from IDisposable.)
Public methodDoughnutGroupsOn 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 methodDrawingObjectsInfrastructure.
Public methodDrawingsInfrastructure.
Public methodDropDownsInfrastructure.
Public methodEndInitSignals the object that initialization is complete. (Inherited from ISupportInitialize.)
Public methodEvaluateConverts a Microsoft Office Excel name to an object or a value.
Public methodExportExports the Microsoft.Office.Tools.Excel.ChartSheet in a graphic format.
Public methodExportAsFixedFormatSaves the chart that is displayed on the ChartSheet in PDF or XPS format.
Public methodget_HasAxisInfrastructure.
Public methodGetChartElementGets information about the chart element at specified X and Y coordinates.
Public methodGroupBoxesInfrastructure.
Public methodGroupObjectsInfrastructure.
Public methodLabelsInfrastructure.
Public methodLineGroupsOn 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 methodLinesInfrastructure.
Public methodListBoxesInfrastructure.
Public methodLocationMoves the Microsoft.Office.Tools.Excel.ChartSheet to a new location.
Public methodMoveMoves the Microsoft.Office.Tools.Excel.ChartSheet to another location in the workbook.
Public methodOLEObjectsGets 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.
Public methodOptionButtonsInfrastructure.
Public methodOvalsInfrastructure.
Public methodPastePastes chart data from the Clipboard into the specified Microsoft.Office.Tools.Excel.ChartSheet.
Public methodPicturesInfrastructure.
Public methodPieGroupsOn 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 methodPrintOutPrints the Microsoft.Office.Tools.Excel.ChartSheet.
Public methodPrintOutExPrints the chart that is displayed on the ChartSheet.
Public methodPrintPreviewShows a preview of the Microsoft.Office.Tools.Excel.ChartSheet as it would look when printed.
Public methodProtectProtects a Microsoft.Office.Tools.Excel.ChartSheet so that it cannot be modified.
Public methodRadarGroupsOn 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 methodRectanglesInfrastructure.
Public methodRefreshUpdates the cache of the Microsoft.Office.Tools.Excel.ChartSheet.
Public methodSaveAsSaves changes to the Microsoft.Office.Tools.Excel.ChartSheet in a different file.
Public methodSaveChartTemplateSaves the chart on the ChartSheet as a custom template in the list of available chart templates.
Public methodScrollBarsInfrastructure.
Public methodSelectSelects the Microsoft.Office.Tools.Excel.ChartSheet.
Public methodSeriesCollectionGets 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 methodset_HasAxisInfrastructure.
Public methodSetBackgroundPictureSets the background graphic for a Microsoft.Office.Tools.Excel.ChartSheet.
Public methodSetDefaultChartSpecifies the name of the chart template that Microsoft Office Excel uses when creating new charts.
Public methodSetElementModifies an element on the chart that is displayed on the ChartSheet.
Public methodSetSourceDataSets the source data range for the Microsoft.Office.Tools.Excel.ChartSheet.
Public methodSpinnersInfrastructure.
Public methodTextBoxesInfrastructure.
Public methodUnprotectRemoves protection from a Microsoft.Office.Tools.Excel.ChartSheet. This method has no effect if the sheet or workbook is not protected.
Public methodXYGroupsOn 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

  NameDescription
Public eventActivateEventOccurs when the Microsoft.Office.Tools.Excel.ChartSheet is activated.
Public eventBeforeDoubleClickOccurs when the Microsoft.Office.Tools.Excel.ChartSheet is double-clicked, before the default double-click action.
Public eventBeforeRightClickOccurs when the Microsoft.Office.Tools.Excel.ChartSheet is right-clicked, before the default right-click action.
Public eventBindingContextChangedInfrastructure.
Public eventCalculateOccurs after the Microsoft.Office.Tools.Excel.ChartSheet plots new or changed data.
Public eventDeactivateOccurs when the selection moves away from the Microsoft.Office.Tools.Excel.ChartSheet, causing the Microsoft.Office.Tools.Excel.ChartSheet to become deactivated.
Public eventDisposedRepresents the method that handles the Disposed event of a component. (Inherited from IComponent.)
Public eventMouseDownOccurs when a mouse button is pressed when the pointer is over a Microsoft.Office.Tools.Excel.ChartSheet.
Public eventMouseMoveOccurs when the position of the mouse pointer changes over the Microsoft.Office.Tools.Excel.ChartSheet.
Public eventMouseUpOccurs when a mouse button is released when the pointer is over the Microsoft.Office.Tools.Excel.ChartSheet.
Public eventResizeOccurs when the size of the Microsoft.Office.Tools.Excel.ChartSheet is changed.
Public eventSelectEventOccurs when the Microsoft.Office.Tools.Excel.ChartSheet is selected.
Public eventSeriesChangeOccurs when the value of a Microsoft.Office.Tools.Excel.ChartSheet data point is changed.
Public eventShutdownOccurs when the application domain for the assembly is about to unload.
Public eventStartupOccurs after the document is running and all the initialization code in the assembly has been run.
Top

A ChartSheet represents a chart sheet; that is, a worksheet that contains only a chart. If you want to create an embedded chart in a worksheet that also contains other items, such as cells or other controls, create a Chart instead.

A ChartSheet provides all the chart-related features of a native Microsoft.Office.Interop.Excel.Chart object in the Excel object model. However, a ChartSheet also exposes events. You can create ChartSheet objects only in a document-level project at design time.

NoteNote

This interface is implemented by the Visual Studio Tools for Office runtime. It is not intended to be implemented in your code. For more information, see Visual Studio Tools for Office Runtime Overview.

Usage

This documentation describes the version of this type that is used in Office projects that target the .NET Framework 4 and the .NET Framework 4.5. In projects that target the .NET Framework 3.5, this type might have different members and the code examples provided for this type might not work. For documentation about this type in projects that target the .NET Framework 3.5, see the following reference section in the Visual Studio 2008 documentation: http://go.microsoft.com/fwlink/?LinkId=160658.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft