ChartSheetBase Class
Provides the base class for chart sheet host items in document-level Office projects for Microsoft Office Excel.
Assembly: Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
| Name | Description | |
|---|---|---|
 | ChartSheetBase(Factory^, IServiceProvider^, String^, String^) | This API supports the product infrastructure and is not intended to be used directly from your code. |
| Name | Description | |
|---|---|---|
 | Application | Gets an Application that represents the Microsoft Office Excel application. |
| AutoScaling | Gets 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 |
| BackWall | Gets an object that represents the back wall of a 3-D chart. |
| BarShape | Gets or sets the shape used with the 3-D bar or column Microsoft.Office.Tools.Excel::ChartSheetBase. |
| Base | Gets the ChartSheet object that this ChartSheetBase object extends. |
| BindingContext | This API supports the product infrastructure and is not intended to be used directly from your code. |
| ChartArea | Gets a ChartArea that represents the complete chart area for the Microsoft.Office.Tools.Excel::ChartSheetBase. |
| ChartStyle | Gets or sets the style of the chart. |
| ChartTitle | Gets a ChartTitle that represents the title of the specified Microsoft.Office.Tools.Excel::ChartSheetBase. |
| ChartType | Gets or sets the Microsoft.Office.Tools.Excel::ChartSheetBase type. |
| Creator | Gets an XlCreator code that indicates the application in which the Microsoft.Office.Tools.Excel::ChartSheetBase was created. |
| DataBindings | This API supports the product infrastructure and is not intended to be used directly from your code. |
| DataHost | This API supports the product infrastructure and is not intended to be used directly from your code. |
| DataTable | Gets a DataTable object that represents the Microsoft.Office.Tools.Excel::ChartSheetBase data table. |
| DepthPercent | Gets or sets the depth of a 3-D chart as a percentage of the Microsoft.Office.Tools.Excel::ChartSheetBase width. |
| DisplayBlanksAs | Gets or sets the way that blank cells are plotted on a Microsoft.Office.Tools.Excel::ChartSheetBase. |
| Elevation | Gets or sets the elevation of the 3-D Microsoft.Office.Tools.Excel::ChartSheetBase, in degrees. |
| Floor | Gets a Floor object that represents the floor of the 3-D Microsoft.Office.Tools.Excel::ChartSheetBase. |
| GapDepth | Gets or sets the distance between the data series in a 3-D Microsoft.Office.Tools.Excel::ChartSheetBase, as a percentage of the marker width. |
| HasAxis | Gets or sets a value indicating whether a specific axis exists on the Microsoft.Office.Tools.Excel::ChartSheetBase. |
| HasDataTable | Gets or sets a value that indicates whether the Microsoft.Office.Tools.Excel::ChartSheetBase has a data table. |
| HasLegend | Gets or sets a value that indicates whether the Microsoft.Office.Tools.Excel::ChartSheetBase has a legend. |
| HasTitle | Gets or sets a value the indicates whether the Microsoft.Office.Tools.Excel::ChartSheetBase has a visible title. |
| HeightPercent | Gets or sets the height of a 3-D chart as a percentage of the Microsoft.Office.Tools.Excel::ChartSheetBase width. |
| HostContext | This API supports the product infrastructure and is not intended to be used directly from your code. |
| Hyperlinks | Gets a Hyperlinks collection that represents the hyperlinks for the Microsoft.Office.Tools.Excel::ChartSheetBase. |
| Index | Gets the index number of the Microsoft.Office.Tools.Excel::ChartSheetBase. |
| InnerObject | Gets a Microsoft.Office.Interop.Excel::Chart that represents the underlying native object for the ChartSheetBase. |
| ItemProvider | This API supports the product infrastructure and is not intended to be used directly from your code. |
| Legend | Gets a Legend that represents the legend for the Microsoft.Office.Tools.Excel::ChartSheetBase. |
| MailEnvelope | Represents an e-mail header for a document. |
| Name | Gets or sets the name of the Microsoft.Office.Tools.Excel::ChartSheetBase. |
| Next | Gets a Microsoft.Office.Interop.Excel::Worksheet object that represents the next sheet. |
| PageSetup | Gets a PageSetup that contains all the page setup settings for the Microsoft.Office.Tools.Excel::ChartSheetBase. |
| Parent | Gets the parent object for the Microsoft.Office.Tools.Excel::ChartSheetBase. |
| Perspective | Gets or sets the perspective for the 3-D Microsoft.Office.Tools.Excel::ChartSheetBase. |
| PivotLayout | Gets a PivotLayout that represents the placement of fields in a PivotTable report and the placement of axes in a PivotChart report. |
| PlotArea | Gets a PlotArea object that represents the plot area of a Microsoft.Office.Tools.Excel::ChartSheetBase. |
| PlotBy | Gets or sets the way columns or rows are used as data series on the Microsoft.Office.Tools.Excel::ChartSheetBase. |
| PlotVisibleOnly | Gets or sets a value that indicates whether only visible cells are plotted. |
| Previous | Gets a Microsoft.Office.Interop.Excel::Worksheet object that represents the previous sheet. |
| PrintedCommentPages | Gets the number of comment pages that will be printed for the current chart sheet. This property can be used only in Excel 2010 projects. |
| ProtectContents | Gets a value that indicates whether the contents of the Microsoft.Office.Tools.Excel::ChartSheetBase are protected. |
| ProtectData | Gets or sets a value that indicates whether series formulas cannot be modified by the user. |
| ProtectDrawingObjects | Gets a value that indicates whether shapes are protected on the Microsoft.Office.Tools.Excel::ChartSheetBase. |
| ProtectFormatting | Gets or sets a value that indicates whether Microsoft.Office.Tools.Excel::ChartSheetBase formatting cannot be modified by the user. |
| ProtectionMode | Gets or sets a value that indicates whether user-interface-only protection is turned on. |
| ProtectSelection | Gets or sets a value that indicates whether Microsoft.Office.Tools.Excel::ChartSheetBase elements cannot be selected. |
| RightAngleAxes | Gets or sets a value that indicates whether the Microsoft.Office.Tools.Excel::ChartSheetBase axes are at right angles, independent of chart rotation or elevation. |
| Rotation | Gets or sets the rotation of the 3-D Microsoft.Office.Tools.Excel::ChartSheetBase. |
| Shapes | Gets a Shapes object that represents all the shapes on the Microsoft.Office.Tools.Excel::ChartSheetBase. |
| ShowAllFieldButtons | Gets 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. |
| ShowAxisFieldButtons | Gets 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. |
| 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. |
| ShowLegendFieldButtons | Gets 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. |
| ShowReportFilterFieldButtons | Gets 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. |
| ShowValueFieldButtons | Gets 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. |
| SideWall | Gets an object that represents the side wall of a 3-D chart. |
| Site | This API supports the product infrastructure and is not intended to be used directly from your code. |
| Tab | Gets a Tab object for a Microsoft.Office.Tools.Excel::ChartSheetBase. |
| Tag | Gets or sets the object that contains data about the ChartSheetBase. |
| Visible | Determines whether the object is visible. |
| Walls | Gets a Walls object that represents the walls of the 3-D Microsoft.Office.Tools.Excel::ChartSheetBase. |
| Name | Description | |
|---|---|---|
 | Activate() | Makes the current Microsoft.Office.Tools.Excel::ChartSheetBase the active chart. |
| ApplyChartTemplate(String^) | Applies a standard or custom chart template to the chart. |
| ApplyDataLabels(XlDataLabelsType, Object^, Object^, Object^, Object^, Object^, Object^, Object^, Object^, Object^) | Applies data labels to a point, a series, or all the series in a Microsoft.Office.Tools.Excel::ChartSheetBase. |
| ApplyLayout(Int32, Object^) | Applies the specified layout to the chart. |
| Axes(Object^, XlAxisGroup) | Gets an object that represents either a single axis or a collection of the axes on the chart. |
| BeginInit() | This API supports the product infrastructure and is not intended to be used directly from your code. |
| ChartGroups(Object^) | 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). |
| ChartObjects(Object^) | 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. |
| ChartWizard(Object^, Object^, Object^, Object^, Object^, Object^, Object^, Object^, Object^, Object^, Object^) | Modifies the properties of the given Microsoft.Office.Tools.Excel::ChartSheetBase. |
| CheckSpelling(Object^, Object^, Object^, Object^) | Checks the spelling of an Microsoft.Office.Tools.Excel::ChartSheetBase. |
| ClearToMatchStyle() | Clears the chart elements formatting to automatic. |
| Copy(Object^, Object^) | Copies the Microsoft.Office.Tools.Excel::ChartSheetBase to another location in the workbook. |
| CopyPicture(XlPictureAppearance, XlCopyPictureFormat, XlPictureAppearance) | Copies the Microsoft.Office.Tools.Excel::ChartSheetBase to the Clipboard as a picture. |
| Delete() | Deletes the Microsoft.Office.Interop.Excel::Chart object. |
| Dispose() | Releases all resources used by the current instance of the ChartSheetBase class. |
| EndInit() | This API supports the product infrastructure and is not intended to be used directly from your code. |
| Equals(Object^) | (Inherited from Object.) |
| Evaluate(Object^) | Converts a Microsoft Office Excel name to an object or a value. |
| Export(String^, Object^, Object^) | Exports the Microsoft.Office.Tools.Excel::ChartSheetBase in a graphic format. |
| ExportAsFixedFormat(XlFixedFormatType, Object^, Object^, Object^, Object^, Object^, Object^, Object^, Object^) | Saves the chart that is displayed on the ChartSheetBase in PDF or XPS format. |
| Finalize() | (Inherited from Object.) |
| FinishInitialization() | This API supports the product infrastructure and is not intended to be used directly from your code. |
| GetAutomationObject() | This API supports the product infrastructure and is not intended to be used directly from your code. |
| GetChartElement(Int32, Int32, Int32%, Int32%, Int32%) | Gets information about the chart element at specified X and Y coordinates. |
| GetHashCode() | (Inherited from Object.) |
| GetType() | (Inherited from Object.) |
| Initialize() | This API supports the product infrastructure and is not intended to be used directly from your code. |
| InitializeDataBindings() | This API supports the product infrastructure and is not intended to be used directly from your code. |
| Location(XlChartLocation, Object^) | Moves the Microsoft.Office.Tools.Excel::ChartSheetBase to a new location. |
| MemberwiseClone() | (Inherited from Object.) |
| Move(Object^, Object^) | Moves the Microsoft.Office.Tools.Excel::ChartSheetBase to another location in the workbook. |
| OLEObjects(Object^) | 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. |
| OnShutdown() | This API supports the product infrastructure and is not intended to be used directly from your code. |
| OnStartup() | This API supports the product infrastructure and is not intended to be used directly from your code. |
| Paste(Object^) | Pastes chart data from the Clipboard into the specified Microsoft.Office.Tools.Excel::ChartSheetBase. |
| PrintOutEx(Object^, Object^, Object^, Object^, Object^, Object^, Object^, Object^) | Prints the chart that is displayed on the ChartSheetBase. |
| PrintPreview(Object^) | Shows a preview of the Microsoft.Office.Tools.Excel::ChartSheetBase as it would look when printed. |
| Protect(Object^, Object^, Object^, Object^, Object^) | Protects a Microsoft.Office.Tools.Excel::ChartSheetBase so that it cannot be modified. |
| Refresh() | Updates the cache of the Microsoft.Office.Tools.Excel::ChartSheetBase. |
| SaveAs(String^, Object^, Object^, Object^, Object^, Object^, Object^, Object^, Object^, Object^) | Saves changes to the Microsoft.Office.Tools.Excel::ChartSheetBase in a different file. |
| SaveChartTemplate(String^) | Saves the chart on the ChartSheetBase as a custom template in the list of available chart templates. |
| Select(Object^) | Selects the Microsoft.Office.Tools.Excel::ChartSheetBase. |
| SeriesCollection(Object^) | 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. |
| SetBackgroundPicture(String^) | Sets the background graphic for a Microsoft.Office.Tools.Excel::ChartSheetBase. |
| SetDefaultChart(Object^) | Specifies the name of the chart template that Microsoft Office Excel uses when creating new charts. |
| SetElement(MsoChartElementType) | Modifies an element on the chart that is displayed on the ChartSheetBase. |
| SetSourceData(Range^, Object^) | Sets the source data range for the Microsoft.Office.Tools.Excel::ChartSheetBase. |
| ToString() | (Inherited from Object.) |
| Unprotect(Object^) | Removes protection from a Microsoft.Office.Tools.Excel::ChartSheetBase. This method has no effect if the sheet or workbook is not protected. |
| Name | Description | |
|---|---|---|
 | ActivateEvent | Occurs when the Microsoft.Office.Tools.Excel::ChartSheetBase is activated. |
| BeforeDoubleClick | Occurs when the Microsoft.Office.Tools.Excel::ChartSheetBase is double-clicked, before the default double-click action. |
| BeforeRightClick | Occurs when the Microsoft.Office.Tools.Excel::ChartSheetBase is right-clicked, before the default right-click action. |
| BindingContextChanged | This API supports the product infrastructure and is not intended to be used directly from your code. |
| Calculate | Occurs after the Microsoft.Office.Tools.Excel::ChartSheetBase plots new or changed data. |
| Deactivate | Occurs when the selection moves away from the Microsoft.Office.Tools.Excel::ChartSheetBase, causing the Microsoft.Office.Tools.Excel::ChartSheetBase to become deactivated. |
| Disposed | This API supports the product infrastructure and is not intended to be used directly from your code. |
| MouseDown | Occurs when a mouse button is pressed when the pointer is over a Microsoft.Office.Tools.Excel::ChartSheetBase. |
| MouseMove | Occurs when the position of the mouse pointer changes over the Microsoft.Office.Tools.Excel::ChartSheetBase. |
| MouseUp | Occurs when a mouse button is released when the pointer is over the Microsoft.Office.Tools.Excel::ChartSheetBase. |
| Resize | Occurs when the size of the Microsoft.Office.Tools.Excel::ChartSheetBase is changed. |
| SelectEvent | Occurs when the Microsoft.Office.Tools.Excel::ChartSheetBase is selected. |
| SeriesChange | Occurs when the value of a Microsoft.Office.Tools.Excel::ChartSheetBase data point is changed. |
| Shutdown | Occurs when the application domain for the assembly is about to unload. |
| Startup | Occurs after the document is running and all the initialization code in the assembly has been run. |
| Name | Description | |
|---|---|---|
  | EntryPoint::BeginInit() | This API supports the product infrastructure and is not intended to be used directly from your code. |
| EntryPoint::EndInit() | This API supports the product infrastructure and is not intended to be used directly from your code. |
| EntryPoint::FinishInitialization() | This API supports the product infrastructure and is not intended to be used directly from your code. |
| EntryPoint::Initialize() | This API supports the product infrastructure and is not intended to be used directly from your code. |
| EntryPoint::InitializeDataBindings() | This API supports the product infrastructure and is not intended to be used directly from your code. |
| EntryPoint::OnShutdown() | This API supports the product infrastructure and is not intended to be used directly from your code. |
| EntryPoint::OnStartup() | This API supports the product infrastructure and is not intended to be used directly from your code. |
| IChartSheetExtension::GetAutomationObject() | This API supports the product infrastructure and is not intended to be used directly from your code. |
 | IExtension::ExtensionBase |
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.
This type is used only in Office projects that target the .NET Framework 4 or later. 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.