Export (0) Print
Expand All

ChartSheetBase Class

Provides the base class for chart sheet host items in document-level Office projects for Microsoft Office Excel.

System.Object
  Microsoft.Office.Tools.Excel.ChartSheetBase

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

'Declaration
Public MustInherit Class ChartSheetBase _
	Implements IChartSheetExtension, IExtension, EntryPoint, ISupportInitialize,  _
	IBindableComponent, IComponent, IDisposable

The ChartSheetBase type exposes the following members.

  NameDescription
Protected methodChartSheetBaseInfrastructure.
Top

  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.ChartSheetBase.
Public propertyAutoScalingGets a value that indicates whether Microsoft Office Excel scales a 3-D Microsoft.Office.Tools.Excel.ChartSheetBase 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.ChartSheetBase.
Public propertyBarShapeGets or sets the shape used with the 3-D bar or column Microsoft.Office.Tools.Excel.ChartSheetBase.
Public propertyBaseGets the ChartSheet object that this ChartSheetBase object extends.
Public propertyBindingContextInfrastructure.
Public propertyChartAreaGets a ChartArea that represents the complete chart area for the Microsoft.Office.Tools.Excel.ChartSheetBase.
Public propertyChartStyleGets or sets the style of the chart.
Public propertyChartTitleGets a ChartTitle that represents the title of the specified Microsoft.Office.Tools.Excel.ChartSheetBase.
Public propertyChartTypeGets or sets the Microsoft.Office.Tools.Excel.ChartSheetBase type.
Public propertyCodeNameInfrastructure.
Public propertyColumn3DGroupGets a ChartGroup that represents the column chart group on a 3-D Microsoft.Office.Tools.Excel.ChartSheetBase.
Public propertyCornersGets a Corners object that represents the corners of a 3-D Microsoft.Office.Tools.Excel.ChartSheetBase.
Public propertyCreatorGets an XlCreator code that indicates the application in which the Microsoft.Office.Tools.Excel.ChartSheetBase was created.
Public propertyDataBindingsInfrastructure.
Public propertyDataHostInfrastructure.
Public propertyDataTableGets a DataTable object that represents the Microsoft.Office.Tools.Excel.ChartSheetBase data table.
Public propertyDepthPercentGets or sets the depth of a 3-D chart as a percentage of the Microsoft.Office.Tools.Excel.ChartSheetBase width.
Public propertyDisplayBlanksAsGets or sets the way that blank cells are plotted on a Microsoft.Office.Tools.Excel.ChartSheetBase.
Public propertyDummy24Infrastructure.
Public propertyDummy25Infrastructure.
Public propertyElevationGets or sets the elevation of the 3-D Microsoft.Office.Tools.Excel.ChartSheetBase, in degrees.
Public propertyFloorGets a Floor object that represents the floor of the 3-D Microsoft.Office.Tools.Excel.ChartSheetBase.
Public propertyGapDepthGets or sets the distance between the data series in a 3-D Microsoft.Office.Tools.Excel.ChartSheetBase, 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.ChartSheetBase.
Public propertyHasDataTableGets or sets a value that indicates whether the Microsoft.Office.Tools.Excel.ChartSheetBase has a data table.
Public propertyHasLegendGets or sets a value that indicates whether the Microsoft.Office.Tools.Excel.ChartSheetBase 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.ChartSheetBase has a visible title.
Public propertyHeightPercentGets or sets the height of a 3-D chart as a percentage of the Microsoft.Office.Tools.Excel.ChartSheetBase width.
Public propertyHostContextInfrastructure.
Public propertyHyperlinksGets a Hyperlinks collection that represents the hyperlinks for the Microsoft.Office.Tools.Excel.ChartSheetBase.
Public propertyIndexGets the index number of the Microsoft.Office.Tools.Excel.ChartSheetBase.
Public propertyInnerObjectGets a Microsoft.Office.Interop.Excel.Chart that represents the underlying native object for the ChartSheetBase.
Public propertyItemProviderInfrastructure.
Public propertyLegendGets a Legend that represents the legend for the Microsoft.Office.Tools.Excel.ChartSheetBase.
Public propertyLine3DGroupGets a ChartGroup that represents the line chart group on a 3-D Microsoft.Office.Tools.Excel.ChartSheetBase.
Public propertyMailEnvelopeRepresents an e-mail header for a document.
Public propertyNameGets or sets the name of the Microsoft.Office.Tools.Excel.ChartSheetBase.
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.ChartSheetBase.
Public propertyParentGets the parent object for the Microsoft.Office.Tools.Excel.ChartSheetBase.
Public propertyPerspectiveGets or sets the perspective for the 3-D Microsoft.Office.Tools.Excel.ChartSheetBase.
Public propertyPie3DGroupGets a ChartGroup that represents the pie chart group on a 3-D Microsoft.Office.Tools.Excel.ChartSheetBase.
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.ChartSheetBase.
Public propertyPlotByGets or sets the way columns or rows are used as data series on the Microsoft.Office.Tools.Excel.ChartSheetBase.
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. This property can be used only in Excel 2010 projects.
Public propertyProtectContentsGets a value that indicates whether the contents of the Microsoft.Office.Tools.Excel.ChartSheetBase 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.ChartSheetBase.
Public propertyProtectFormattingGets or sets a value that indicates whether Microsoft.Office.Tools.Excel.ChartSheetBase 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.ChartSheetBase elements cannot be selected.
Public propertyRightAngleAxesGets or sets a value that indicates whether the Microsoft.Office.Tools.Excel.ChartSheetBase 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.ChartSheetBase.
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.ChartSheetBase.
Public propertyShowAllFieldButtonsGets or sets whether to display all field buttons on a PivotChart that is displayed on the ChartSheetBase. This property can be used only in Excel 2010 projects.
Public propertyShowAxisFieldButtonsGets or sets whether to display axis field buttons on a PivotChart that is displayed on the ChartSheetBase. This property can be used only in Excel 2010 projects.
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 ChartSheetBase. This property can be used only in Excel 2010 projects.
Public propertyShowReportFilterFieldButtonsGets or sets whether to display the report filter field buttons on a PivotChart that is displayed on the ChartSheetBase. This property can be used only in Excel 2010 projects.
Public propertyShowValueFieldButtonsGets or sets whether to display the value field buttons on a PivotChart that is displayed on the ChartSheetBase. This property can be used only in Excel 2010 projects.
Public propertySideWallGets an object that represents the side wall of a 3-D chart.
Public propertySiteInfrastructure.
Public propertySubTypeInfrastructure.
Public propertySurfaceGroupGets a ChartGroup object that represents the surface chart group of a 3-D Microsoft.Office.Tools.Excel.ChartSheetBase.
Public propertyTabGets a Tab object for a Microsoft.Office.Tools.Excel.ChartSheetBase.
Public propertyTagGets or sets the object that contains data about the ChartSheetBase.
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.ChartSheetBase.
Public propertyWallsAndGridlines2DGets or sets a value that indicates whether gridlines are drawn two-dimensionally on a 3-D Microsoft.Office.Tools.Excel.ChartSheetBase.
Top

  NameDescription
Public methodActivateMakes the current Microsoft.Office.Tools.Excel.ChartSheetBase 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.ChartSheetBase.
Public methodApplyDataLabelsApplies data labels to a point, a series, or all the series in a Microsoft.Office.Tools.Excel.ChartSheetBase.
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 methodBeginInitInfrastructure.
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.ChartSheetBase.
Public methodCheckBoxesInfrastructure.
Public methodCheckSpellingChecks the spelling of an Microsoft.Office.Tools.Excel.ChartSheetBase.
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.ChartSheetBase to another location in the workbook.
Public methodCopyChartBuildInfrastructure.
Public methodCopyPictureCopies the Microsoft.Office.Tools.Excel.ChartSheetBase 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.ChartSheetBase.
Public methodDisposeReleases all resources used by the current instance of the ChartSheetBase class.
Public methodDoughnutGroupsOn a 2-D Microsoft.Office.Tools.Excel.ChartSheetBase, 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 methodEndInitInfrastructure.
Public methodEqualsDetermines whether the specified object is equal to the current object. (Inherited from Object.)
Public methodEvaluateConverts a Microsoft Office Excel name to an object or a value.
Public methodExportExports the Microsoft.Office.Tools.Excel.ChartSheetBase in a graphic format.
Public methodExportAsFixedFormatSaves the chart that is displayed on the ChartSheetBase in PDF or XPS format.
Protected methodFinalizeAllows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
Protected methodFinishInitializationInfrastructure.
Public methodget_HasAxisInfrastructure.
Protected methodGetAutomationObjectInfrastructure.
Public methodGetChartElementGets information about the chart element at specified X and Y coordinates.
Public methodGetHashCodeServes as the default hash function. (Inherited from Object.)
Public methodGetTypeGets the Type of the current instance. (Inherited from Object.)
Public methodGroupBoxesInfrastructure.
Public methodGroupObjectsInfrastructure.
Protected methodInitializeInfrastructure.
Protected methodInitializeDataBindingsInfrastructure.
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.ChartSheetBase to a new location.
Protected methodMemberwiseCloneCreates a shallow copy of the current Object. (Inherited from Object.)
Public methodMoveMoves the Microsoft.Office.Tools.Excel.ChartSheetBase 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.
Protected methodOnShutdownInfrastructure.
Protected methodOnStartupInfrastructure.
Public methodOptionButtonsInfrastructure.
Public methodOvalsInfrastructure.
Public methodPastePastes chart data from the Clipboard into the specified Microsoft.Office.Tools.Excel.ChartSheetBase.
Public methodPicturesInfrastructure.
Public methodPieGroupsOn a 2-D Microsoft.Office.Tools.Excel.ChartSheetBase, 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.ChartSheetBase.
Public methodPrintOutExPrints the chart that is displayed on the ChartSheetBase.
Public methodPrintPreviewShows a preview of the Microsoft.Office.Tools.Excel.ChartSheetBase as it would look when printed.
Public methodProtectProtects a Microsoft.Office.Tools.Excel.ChartSheetBase so that it cannot be modified.
Public methodRadarGroupsOn a 2-D Microsoft.Office.Tools.Excel.ChartSheetBase, 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.ChartSheetBase.
Public methodSaveAsSaves changes to the Microsoft.Office.Tools.Excel.ChartSheetBase in a different file.
Public methodSaveChartTemplateSaves the chart on the ChartSheetBase as a custom template in the list of available chart templates.
Public methodScrollBarsInfrastructure.
Public methodSelectSelects the Microsoft.Office.Tools.Excel.ChartSheetBase.
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.ChartSheetBase.
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 ChartSheetBase.
Public methodSetSourceDataSets the source data range for the Microsoft.Office.Tools.Excel.ChartSheetBase.
Public methodSpinnersInfrastructure.
Public methodTextBoxesInfrastructure.
Public methodToStringReturns a string that represents the current object. (Inherited from Object.)
Public methodUnprotectRemoves protection from a Microsoft.Office.Tools.Excel.ChartSheetBase. This method has no effect if the sheet or workbook is not protected.
Public methodXYGroupsOn a 2-D Microsoft.Office.Tools.Excel.ChartSheetBase, 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.ChartSheetBase is activated.
Public eventBeforeDoubleClickOccurs when the Microsoft.Office.Tools.Excel.ChartSheetBase is double-clicked, before the default double-click action.
Public eventBeforeRightClickOccurs when the Microsoft.Office.Tools.Excel.ChartSheetBase is right-clicked, before the default right-click action.
Public eventBindingContextChangedInfrastructure.
Public eventCalculateOccurs after the Microsoft.Office.Tools.Excel.ChartSheetBase plots new or changed data.
Public eventDeactivateOccurs when the selection moves away from the Microsoft.Office.Tools.Excel.ChartSheetBase, causing the Microsoft.Office.Tools.Excel.ChartSheetBase to become deactivated.
Public eventDisposedInfrastructure.
Public eventMouseDownOccurs when a mouse button is pressed when the pointer is over a Microsoft.Office.Tools.Excel.ChartSheetBase.
Public eventMouseMoveOccurs when the position of the mouse pointer changes over the Microsoft.Office.Tools.Excel.ChartSheetBase.
Public eventMouseUpOccurs when a mouse button is released when the pointer is over the Microsoft.Office.Tools.Excel.ChartSheetBase.
Public eventResizeOccurs when the size of the Microsoft.Office.Tools.Excel.ChartSheetBase is changed.
Public eventSelectEventOccurs when the Microsoft.Office.Tools.Excel.ChartSheetBase is selected.
Public eventSeriesChangeOccurs when the value of a Microsoft.Office.Tools.Excel.ChartSheetBase 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

The ChartSheetBase class is the base class for chart sheet host items in document-level Office projects created by using Visual Studio.

A chart sheet 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.

The ChartSheetBase class provides all the chart-related features of a native Microsoft.Office.Interop.Excel.Chart object in the Excel primary interop assembly. However, a ChartSheetBase also exposes events.

Usage

This type is used only in Office projects that target the .NET Framework 4 and the .NET Framework 4.5. The assembly that defines this type is not part of the Visual Studio Tools for Office runtime. You must deploy this assembly with your solution. For more information, see Assemblies in the Visual Studio Tools for Office Runtime.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Show:
© 2014 Microsoft