_Chart Members
Represents a chart in a workbook. The chart can be either an embedded chart (contained in a ChartObject) or a separate chart sheet.
The following tables list the members exposed by the _Chart type.
Public Properties
| Name | Description | |
|---|---|---|
.gif) |
_CodeName | |
|
Application | When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). |
|
Area3DGroup | Returns a ChartGroup object that represents the area chart group on a 3-D chart. |
|
AutoScaling | True if Microsoft Excel scales a 3-D chart so that it's closer in size to the equivalent 2-D chart. The RightAngleAxes property must be True. |
|
Bar3DGroup | Returns a ChartGroup object that represents the bar chart group on a 3-D chart. |
|
BarShape | Returns or sets the shape used with the 3-D bar or column chart. |
|
ChartArea | Returns a ChartArea object that represents the complete chart area for the chart. |
|
ChartTitle | Returns a ChartTitle object that represents the title of the specified chart. |
|
ChartType | Returns or sets the chart type. |
|
CodeName | Returns the code name for the object. |
|
Column3DGroup | Returns a ChartGroup object that represents the column chart group on a 3-D chart. |
|
Corners | Returns a Corners object that represents the corners of a 3-D chart. |
|
Creator | Returns a 32-bit integer that indicates the application in which this object was created. If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C. |
|
DataTable | Returns a DataTable object that represents the chart data table. |
|
DepthPercent | Returns or sets the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent). |
|
DisplayBlanksAs | Returns or sets the way that blank cells are plotted on a chart. Can be one of the following XlDisplayBlanksAs constants: xlNotPlotted, xlInterpolated, or xlZero. |
|
Elevation | Returns or sets the elevation of the 3-D chart view in degrees. |
|
Floor | Returns a Floor object that represents the floor of the 3-D chart. |
|
GapDepth | Returns or sets the distance between the data series in a 3-D chart as a percentage of the marker width. The value of this property must be between 0 and 500. |
|
HasAxis | Returns or sets which axes exist on the chart. |
|
HasDataTable | True if the chart has a data table. |
|
HasLegend | True if the chart has a legend. |
|
HasPivotFields | True if the PivotChart controls are displayed on the specified PivotChart report. The default value is True. For a regular chart, this property always returns False and cannot be set. |
|
HasTitle | True if the axis or chart has a visible title. |
|
HeightPercent | Returns or sets the height of a 3-D chart as a percentage of the chart width (between 5 and 500 percent). |
|
Hyperlinks | Returns a Hyperlinks collection that represents the hyperlinks for the range or worksheet. |
|
Index | Returns the index number of the object within the collection of similar objects. |
|
Legend | Returns a Legend object that represents the legend for the chart. |
|
Line3DGroup | Returns a ChartGroup object that represents the line chart group on a 3-D chart. |
|
MailEnvelope | Represents an e-mail header for a document. |
|
Name | Returns or sets the name of the object. |
|
Next | Returns a Chart object that represents the next sheet or cell. |
|
OnDoubleClick | |
|
OnSheetActivate | |
|
OnSheetDeactivate | |
|
PageSetup | Returns a PageSetup object that contains all the page setup settings for the specified object. |
|
Parent | Returns the parent object for the specified object. |
|
Perspective | Returns or sets the perspective for the 3-D chart view. Must be between 0 and 100. This property is ignored if the RightAngleAxes property is True. |
|
Pie3DGroup | Returns a ChartGroup object that represents the pie chart group on a 3-D chart. |
|
PivotLayout | Returns a PivotLayout object that represents the placement of fields in a PivotTable report and the placement of axes in a PivotChart report. |
|
PlotArea | Returns a PlotArea object that represents the plot area of a chart. |
|
PlotBy | Returns or sets the way columns or rows are used as data series on the chart. Can be one of the following XlRowCol constants: xlColumns or xlRows. For PivotChart reports, this property is read-only and always returns xlColumns. |
|
PlotVisibleOnly | True if only visible cells are plotted. False if both visible and hidden cells are plotted. |
|
Previous | Returns a Chart object that represents the previous sheet or cell. |
|
ProtectContents | True if the contents of the sheet are protected. This protects the entire chart. |
|
ProtectData | True if series formulas cannot be modified by the user. |
|
ProtectDrawingObjects | True if shapes are protected. |
|
ProtectFormatting | True if chart formatting cannot be modified by the user. |
|
ProtectGoalSeek | True if the user cannot modify chart data points with mouse actions. |
|
ProtectionMode | True if user-interface-only protection is turned on. To turn on user interface protection, use the Protect method with the UserInterfaceOnly argument set to True. |
|
ProtectSelection | True if chart elements cannot be selected. |
|
RightAngleAxes | True if the chart axes are at right angles, independent of chart rotation or elevation. Applies only to 3-D line, column, and bar charts. |
|
Rotation | Returns or sets the rotation of the 3-D chart view (the rotation of the plot area around the z-axis in degrees). The value of this property must be from 0 to 360, except for 3-D bar charts, where the value must be from 0 to 44. The default value is 20. Applies only to 3-D charts. |
|
Scripts | Returns the Microsoft.Office.Core.Scripts collection, which contains Microsoft.Office.Core.Script objects representing blocks of script or code in the specified document when it’s saved as a Web page. |
|
Shapes | Returns a Shapes object that represents all the shapes on the worksheet or chart sheet. Read-only. |
|
ShowWindow | True if the embedded chart is displayed in a separate window. The Chart object used with this property must refer to an embedded chart. |
|
SizeWithWindow | True if Microsoft Excel resizes the chart to match the size of the chart sheet window. False if the chart size isn't attached to the window size. Applies only to chart sheets (doesn't apply to embedded charts). |
|
SubType | |
|
SurfaceGroup | Returns a ChartGroup object that represents the surface chart group of a 3-D chart. |
|
Tab | Returns a Tab object for a chart or a worksheet. |
|
Type | |
|
Visible | Determines whether the object is visible. |
|
Walls | Returns a Walls object that represents the walls of the 3-D chart. |
|
WallsAndGridlines2D | True if gridlines are drawn two-dimensionally on a 3-D chart. |
Top
Public Methods
| Name | Description | |
|---|---|---|
.gif) |
_ApplyDataLabels | |
|
_Dummy23 | |
|
_Evaluate | |
|
_PrintOut | |
|
_Protect | |
|
_SaveAs | |
|
Activate | Makes the current chart the active chart. |
|
ApplyCustomType | Applies a standard or custom chart type to a chart. |
|
ApplyDataLabels | Applies data labels to a point, a series, or all the series in a chart. |
|
Arcs | |
|
AreaGroups | On 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). |
|
AutoFormat | |
|
Axes | Returns an object that represents either a single axis or a collection of the axes on the chart. |
|
BarGroups | On 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). |
|
Buttons | |
|
ChartGroups | Returns 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). The returned collection includes every type of group. |
|
ChartObjects | Returns 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 | Modifies the properties of the given chart. You can use this method to quickly format a chart without setting all the individual properties. This method is non-interactive, and it changes only the specified properties. |
|
CheckBoxes | |
|
CheckSpelling | Checks the spelling of an object and displays the Spelling dialog box |
|
ColumnGroups | On 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). |
|
Copy | Copies the sheet to another location in the workbook. |
|
CopyChartBuild | |
|
CopyPicture | Copies the selected object to the Clipboard as a picture. |
|
CreatePublisher | This member is used only on the Macintosh. For information about this member, consult the language reference Help included with Microsoft Office Macintosh Edition. |
|
Delete | Deletes the object. |
|
Deselect | Cancels the selection for the specified chart. |
|
DoughnutGroups | On a 2-D chart, 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). |
|
DrawingObjects | |
|
Drawings | |
|
DropDowns | |
|
Evaluate | Converts a Microsoft Excel name to an object or a value. |
|
Export | Exports the chart in a graphic format. |
|
GetChartElement | Returns information about the chart element at specified X and Y coordinates. This method is unusual in that you specify values for only the first two arguments. Microsoft Excel fills in the other arguments, and your code should examine those values when the method returns. |
|
GroupBoxes | |
|
GroupObjects | |
|
Labels | |
|
LineGroups | On 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). |
|
Lines | f |
|
ListBoxes | |
|
Location | Moves the chart to a new location. |
|
Move | Moves the sheet to another location in the workbook. |
|
OLEObjects | Returns 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. |
|
OptionButtons | |
|
Ovals | |
|
Paste | Pastes chart data from the Clipboard into the specified chart. |
|
Pictures | |
|
PieGroups | On a 2-D chart, 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). |
|
PrintOut | Prints the object. |
|
PrintPreview | Shows a preview of the object as it would look when printed. |
|
Protect | Protects a chart so that it cannot be modified. |
|
RadarGroups | On a 2-D chart, 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). |
|
Rectangles | |
|
Refresh | Updates the cache of the Chart or PivotTable object. |
|
SaveAs | Saves changes to the chart or worksheet in a different file. |
|
ScrollBars | |
|
Select | Selects the object. |
|
SeriesCollection | Returns 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 | Sets the background graphic for a worksheet or chart. |
|
SetSourceData | Sets the source data range for the chart. |
|
Spinners | |
|
TextBoxes | |
|
Unprotect | Removes protection from a sheet or workbook. This method has no effect if the sheet or workbook isn't protected. |
|
XYGroups | On a 2-D chart, 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