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
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

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

NameDescription
System_CAPS_pubpropertyApplication

Gets an Application that represents the Microsoft Office Excel application.

System_CAPS_pubpropertyAutoScaling

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

System_CAPS_pubpropertyBackWall

Gets an object that represents the back wall of a 3-D chart.

System_CAPS_pubpropertyBarShape

Gets or sets the shape used with the 3-D bar or column Microsoft.Office.Tools.Excel.ChartSheet.

System_CAPS_pubpropertyBindingContext

(Inherited from IBindableComponent.)

System_CAPS_pubpropertyChartArea

Gets a ChartArea that represents the complete chart area for the Microsoft.Office.Tools.Excel.ChartSheet.

System_CAPS_pubpropertyChartStyle

Gets or sets the style of the chart.

System_CAPS_pubpropertyChartTitle

Gets a ChartTitle that represents the title of the specified Microsoft.Office.Tools.Excel.ChartSheet.

System_CAPS_pubpropertyChartType

Gets or sets the Microsoft.Office.Tools.Excel.ChartSheet type.

System_CAPS_pubpropertyCreator

Gets an XlCreator code that indicates the application in which the Microsoft.Office.Tools.Excel.ChartSheet was created.

System_CAPS_pubpropertyDataBindings

(Inherited from IBindableComponent.)

System_CAPS_pubpropertyDataHost

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubpropertyDataTable

Gets a DataTable object that represents the Microsoft.Office.Tools.Excel.ChartSheet data table.

System_CAPS_pubpropertyDefaultExtension

Gets the default extension for this ChartSheet object.

System_CAPS_pubpropertyDepthPercent

Gets or sets the depth of a 3-D chart as a percentage of the Microsoft.Office.Tools.Excel.ChartSheet width.

System_CAPS_pubpropertyDisplayBlanksAs

Gets or sets the way that blank cells are plotted on a Microsoft.Office.Tools.Excel.ChartSheet.

System_CAPS_pubpropertyElevation

Gets or sets the elevation of the 3-D Microsoft.Office.Tools.Excel.ChartSheet, in degrees.

System_CAPS_pubpropertyExtension

Gets a custom extension for this ChartSheet object.

System_CAPS_pubpropertyFloor

Gets a Floor object that represents the floor of the 3-D Microsoft.Office.Tools.Excel.ChartSheet.

System_CAPS_pubpropertyGapDepth

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.

System_CAPS_pubpropertyHasAxis

Gets or sets a value indicating whether a specific axis exists on the Microsoft.Office.Tools.Excel.ChartSheet.

System_CAPS_pubpropertyHasDataTable

Gets or sets a value that indicates whether the Microsoft.Office.Tools.Excel.ChartSheet has a data table.

System_CAPS_pubpropertyHasLegend

Gets or sets a value that indicates whether the Microsoft.Office.Tools.Excel.ChartSheet has a legend.

System_CAPS_pubpropertyHasTitle

Gets or sets a value the indicates whether the Microsoft.Office.Tools.Excel.ChartSheet has a visible title.

System_CAPS_pubpropertyHeightPercent

Gets or sets the height of a 3-D chart as a percentage of the Microsoft.Office.Tools.Excel.ChartSheet width.

System_CAPS_pubpropertyHostContext

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubpropertyHyperlinks

Gets a Hyperlinks collection that represents the hyperlinks for the Microsoft.Office.Tools.Excel.ChartSheet.

System_CAPS_pubpropertyIndex

Gets the index number of the Microsoft.Office.Tools.Excel.ChartSheet.

System_CAPS_pubpropertyInnerObject

Gets a Microsoft.Office.Interop.Excel.Chart that represents the underlying native object for the ChartSheet.

System_CAPS_pubpropertyItemProvider

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubpropertyLegend

Gets a Legend that represents the legend for the Microsoft.Office.Tools.Excel.ChartSheet.

System_CAPS_pubpropertyMailEnvelope

Represents an e-mail header for a document.

System_CAPS_pubpropertyName

Gets or sets the name of the Microsoft.Office.Tools.Excel.ChartSheet.

System_CAPS_pubpropertyNext

Gets a Microsoft.Office.Interop.Excel.Worksheet object that represents the next sheet.

System_CAPS_pubpropertyPageSetup

Gets a PageSetup that contains all the page setup settings for the Microsoft.Office.Tools.Excel.ChartSheet.

System_CAPS_pubpropertyParent

Gets the parent object for the Microsoft.Office.Tools.Excel.ChartSheet.

System_CAPS_pubpropertyPerspective

Gets or sets the perspective for the 3-D Microsoft.Office.Tools.Excel.ChartSheet.

System_CAPS_pubpropertyPivotLayout

Gets a PivotLayout that represents the placement of fields in a PivotTable report and the placement of axes in a PivotChart report.

System_CAPS_pubpropertyPlotArea

Gets a PlotArea object that represents the plot area of a Microsoft.Office.Tools.Excel.ChartSheet.

System_CAPS_pubpropertyPlotBy

Gets or sets the way columns or rows are used as data series on the Microsoft.Office.Tools.Excel.ChartSheet.

System_CAPS_pubpropertyPlotVisibleOnly

Gets or sets a value that indicates whether only visible cells are plotted.

System_CAPS_pubpropertyPrevious

Gets a Microsoft.Office.Interop.Excel.Worksheet object that represents the previous sheet.

System_CAPS_pubpropertyPrintedCommentPages

Gets the number of comment pages that will be printed for the current chart sheet.

System_CAPS_pubpropertyProtectContents

Gets a value that indicates whether the contents of the Microsoft.Office.Tools.Excel.ChartSheet are protected.

System_CAPS_pubpropertyProtectData

Gets or sets a value that indicates whether series formulas cannot be modified by the user.

System_CAPS_pubpropertyProtectDrawingObjects

Gets a value that indicates whether shapes are protected on the Microsoft.Office.Tools.Excel.ChartSheet.

System_CAPS_pubpropertyProtectFormatting

Gets or sets a value that indicates whether Microsoft.Office.Tools.Excel.ChartSheet formatting cannot be modified by the user.

System_CAPS_pubpropertyProtectionMode

Gets or sets a value that indicates whether user-interface-only protection is turned on.

System_CAPS_pubpropertyProtectSelection

Gets or sets a value that indicates whether Microsoft.Office.Tools.Excel.ChartSheet elements cannot be selected.

System_CAPS_pubpropertyRightAngleAxes

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.

System_CAPS_pubpropertyRotation

Gets or sets the rotation of the 3-D Microsoft.Office.Tools.Excel.ChartSheet.

System_CAPS_pubpropertyShapes

Gets a Shapes object that represents all the shapes on the Microsoft.Office.Tools.Excel.ChartSheet.

System_CAPS_pubpropertyShowAllFieldButtons

Gets or sets whether to display all field buttons on a PivotChart that is displayed on the ChartSheet.

System_CAPS_pubpropertyShowAxisFieldButtons

Gets or sets whether to display axis field buttons on a PivotChart that is displayed on the ChartSheet.

System_CAPS_pubpropertyShowDataLabelsOverMaximum

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.

System_CAPS_pubpropertyShowLegendFieldButtons

Gets or sets whether to display legend field buttons on a PivotChart that is displayed on the ChartSheet.

System_CAPS_pubpropertyShowReportFilterFieldButtons

Gets or sets whether to display the report filter field buttons on a PivotChart that is displayed on the ChartSheet.

System_CAPS_pubpropertyShowValueFieldButtons

Gets or sets whether to display the value field buttons on a PivotChart that is displayed on the ChartSheet.

System_CAPS_pubpropertySideWall

Gets an object that represents the side wall of a 3-D chart.

System_CAPS_pubpropertySite

(Inherited from IComponent.)

System_CAPS_pubpropertyTab

Gets a Tab object for a Microsoft.Office.Tools.Excel.ChartSheet.

System_CAPS_pubpropertyTag

Gets or sets the object that contains data about the ChartSheet.

System_CAPS_pubpropertyVisible

Determines whether the object is visible.

System_CAPS_pubpropertyWalls

Gets a Walls object that represents the walls of the 3-D Microsoft.Office.Tools.Excel.ChartSheet.

NameDescription
System_CAPS_pubmethodActivate()

Makes the current Microsoft.Office.Tools.Excel.ChartSheet the active chart.

System_CAPS_pubmethodApplyChartTemplate(String)

Applies a standard or custom chart template to the chart.

System_CAPS_pubmethodApplyDataLabels(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.ChartSheet.

System_CAPS_pubmethodApplyLayout(Int32, Object)

Applies the specified layout to the chart.

System_CAPS_pubmethodAxes(Object, XlAxisGroup)

Gets an object that represents either a single axis or a collection of the axes on the chart.

System_CAPS_pubmethodBeginInit()

(Inherited from ISupportInitialize.)

System_CAPS_pubmethodChartGroups(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 T:Microsoft.Office.Interop.Excel.ChartGroups object).

System_CAPS_pubmethodChartObjects(Object)

Gets an object that represents either a single embedded chart (a T:Microsoft.Office.Interop.Excel.ChartObject object) or a collection of all the embedded charts (a T:Microsoft.Office.Interop.Excel.ChartObjects object) on the sheet.

System_CAPS_pubmethodChartWizard(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)

Modifies the properties of the given Microsoft.Office.Tools.Excel.ChartSheet.

System_CAPS_pubmethodCheckSpelling(Object, Object, Object, Object)

Checks the spelling of an Microsoft.Office.Tools.Excel.ChartSheet.

System_CAPS_pubmethodClearToMatchStyle()

Clears the chart elements formatting to automatic.

System_CAPS_pubmethodCopy(Object, Object)

Copies the Microsoft.Office.Tools.Excel.ChartSheet to another location in the workbook.

System_CAPS_pubmethodCopyPicture(XlPictureAppearance, XlCopyPictureFormat, XlPictureAppearance)

Copies the Microsoft.Office.Tools.Excel.ChartSheet to the Clipboard as a picture.

System_CAPS_pubmethodDelete()
System_CAPS_pubmethodDispose()

(Inherited from IDisposable.)

System_CAPS_pubmethodEndInit()

(Inherited from ISupportInitialize.)

System_CAPS_pubmethodEvaluate(Object)

Converts a Microsoft Office Excel name to an object or a value.

System_CAPS_pubmethodExport(String, Object, Object)

Exports the Microsoft.Office.Tools.Excel.ChartSheet in a graphic format.

System_CAPS_pubmethodExportAsFixedFormat(XlFixedFormatType, Object, Object, Object, Object, Object, Object, Object, Object)

Saves the chart that is displayed on the ChartSheet in PDF or XPS format.

System_CAPS_pubmethodGetChartElement(Int32, Int32, Int32, Int32, Int32)

Gets information about the chart element at specified X and Y coordinates.

System_CAPS_pubmethodLocation(XlChartLocation, Object)

Moves the Microsoft.Office.Tools.Excel.ChartSheet to a new location.

System_CAPS_pubmethodMove(Object, Object)

Moves the Microsoft.Office.Tools.Excel.ChartSheet to another location in the workbook.

System_CAPS_pubmethodOLEObjects(Object)

Gets an object that represents either a single OLE object (an T:Microsoft.Office.Interop.Excel.OLEObject) or a collection of all OLE objects (an T:Microsoft.Office.Interop.Excel.OLEObjects collection) on the chart or sheet.

System_CAPS_pubmethodPaste(Object)

Pastes chart data from the Clipboard into the specified Microsoft.Office.Tools.Excel.ChartSheet.

System_CAPS_pubmethodPrintOutEx(Object, Object, Object, Object, Object, Object, Object, Object)

Prints the chart that is displayed on the ChartSheet.

System_CAPS_pubmethodPrintPreview(Object)

Shows a preview of the Microsoft.Office.Tools.Excel.ChartSheet as it would look when printed.

System_CAPS_pubmethodProtect(Object, Object, Object, Object, Object)

Protects a Microsoft.Office.Tools.Excel.ChartSheet so that it cannot be modified.

System_CAPS_pubmethodRefresh()

Updates the cache of the Microsoft.Office.Tools.Excel.ChartSheet.

System_CAPS_pubmethodSaveAs(String, Object, Object, Object, Object, Object, Object, Object, Object, Object)

Saves changes to the Microsoft.Office.Tools.Excel.ChartSheet in a different file.

System_CAPS_pubmethodSaveChartTemplate(String)

Saves the chart on the ChartSheet as a custom template in the list of available chart templates.

System_CAPS_pubmethodSelect(Object)

Selects the Microsoft.Office.Tools.Excel.ChartSheet.

System_CAPS_pubmethodSeriesCollection(Object)

Gets an object that represents either a single series (a T:Microsoft.Office.Interop.Excel.Series object) or a collection of all the series (a T:Microsoft.Office.Interop.Excel.SeriesCollection collection) in the chart or chart group.

System_CAPS_pubmethodSetBackgroundPicture(String)

Sets the background graphic for a Microsoft.Office.Tools.Excel.ChartSheet.

System_CAPS_pubmethodSetDefaultChart(Object)

Specifies the name of the chart template that Microsoft Office Excel uses when creating new charts.

System_CAPS_pubmethodSetElement(MsoChartElementType)

Modifies an element on the chart that is displayed on the ChartSheet.

System_CAPS_pubmethodSetSourceData(Range, Object)

Sets the source data range for the Microsoft.Office.Tools.Excel.ChartSheet.

System_CAPS_pubmethodUnprotect(Object)

Removes protection from a Microsoft.Office.Tools.Excel.ChartSheet. This method has no effect if the sheet or workbook is not protected.

NameDescription
System_CAPS_pubeventActivateEvent

Occurs when the Microsoft.Office.Tools.Excel.ChartSheet is activated.

System_CAPS_pubeventBeforeDoubleClick

Occurs when the Microsoft.Office.Tools.Excel.ChartSheet is double-clicked, before the default double-click action.

System_CAPS_pubeventBeforeRightClick

Occurs when the Microsoft.Office.Tools.Excel.ChartSheet is right-clicked, before the default right-click action.

System_CAPS_pubeventBindingContextChanged

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubeventCalculate

Occurs after the Microsoft.Office.Tools.Excel.ChartSheet plots new or changed data.

System_CAPS_pubeventDeactivate

Occurs when the selection moves away from the Microsoft.Office.Tools.Excel.ChartSheet, causing the Microsoft.Office.Tools.Excel.ChartSheet to become deactivated.

System_CAPS_pubeventDisposed

(Inherited from IComponent.)

System_CAPS_pubeventMouseDown

Occurs when a mouse button is pressed when the pointer is over a Microsoft.Office.Tools.Excel.ChartSheet.

System_CAPS_pubeventMouseMove

Occurs when the position of the mouse pointer changes over the Microsoft.Office.Tools.Excel.ChartSheet.

System_CAPS_pubeventMouseUp

Occurs when a mouse button is released when the pointer is over the Microsoft.Office.Tools.Excel.ChartSheet.

System_CAPS_pubeventResize

Occurs when the size of the Microsoft.Office.Tools.Excel.ChartSheet is changed.

System_CAPS_pubeventSelectEvent

Occurs when the Microsoft.Office.Tools.Excel.ChartSheet is selected.

System_CAPS_pubeventSeriesChange

Occurs when the value of a Microsoft.Office.Tools.Excel.ChartSheet data point is changed.

System_CAPS_pubeventShutdown

Occurs when the application domain for the assembly is about to unload.

System_CAPS_pubeventStartup

Occurs after the document is running and all the initialization code in the assembly has been run.

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.

System_CAPS_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.

This documentation describes the version of this type that is used in Office projects that target the .NET Framework 4 or later. 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.

Return to top
Show: