Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

_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 _Chart type exposes the following members.

  Name Description
Public property _CodeName Reserved for internal use.
Public property 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).
Public property Area3DGroup Returns a ChartGroup object that represents the area chart group on a 3-D chart.
Public property 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.
Public property BackWall Returns a Walls object that allows the user to individually format the back wall of a 3-D chart. Read-only.
Public property Bar3DGroup Returns a ChartGroup object that represents the bar chart group on a 3-D chart.
Public property BarShape Returns or sets the shape used with the 3-D bar or column chart.
Public property ChartArea Returns a ChartArea object that represents the complete chart area for the chart.
Public property ChartStyle Returns or sets the chart style for the chart. Read/write.
Public property ChartTitle Returns a ChartTitle object that represents the title of the specified chart.
Public property ChartType Returns or sets the chart type.
Public property CodeName Returns the code name for the object.
Public property Column3DGroup Returns a ChartGroup object that represents the column chart group on a 3-D chart.
Public property Corners Returns a Corners object that represents the corners of a 3-D chart.
Public property Creator Returns a constant in the XlCreator enumeration 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.
Public property DataTable Returns a DataTable object that represents the chart data table.
Public property DepthPercent Returns or sets the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent).
Public property 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.
Public property Elevation Returns or sets the elevation of the 3-D chart view in degrees.
Public property Floor Returns a Floor object that represents the floor of the 3-D chart.
Public property 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.
Public property HasAxis Returns or sets which axes exist on the chart.
Public property HasDataTable True if the chart has a data table.
Public property HasLegend True if the chart has a legend.
Public property 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.
Public property HasTitle True if the axis or chart has a visible title.
Public property HeightPercent Returns or sets the height of a 3-D chart as a percentage of the chart width (between 5 and 500 percent).
Public property Hyperlinks Returns a Hyperlinks collection that represents the hyperlinks for the range or worksheet.
Public property Index Returns the index number of the object within the collection of similar objects.
Public property InDraftMode
Public property Legend Returns a Legend object that represents the legend for the chart.
Public property Line3DGroup Returns a ChartGroup object that represents the line chart group on a 3-D chart.
Public property MailEnvelope Represents an e-mail header for a document.
Public property Name Returns or sets the name of the object.
Public property Next Returns a Chart object that represents the next sheet or cell.
Public property OnDoubleClick Reserved for internal use.
Public property OnSheetActivate Reserved for internal use.
Public property OnSheetDeactivate Reserved for internal use.
Public property PageSetup Returns a PageSetup object that contains all the page setup settings for the specified object.
Public property Parent Returns the parent object for the specified object.
Public property 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.
Public property Pie3DGroup Returns a ChartGroup object that represents the pie chart group on a 3-D chart.
Public property PivotLayout Returns a PivotLayout object that represents the placement of fields in a PivotTable report and the placement of axes in a PivotChart report.
Public property PlotArea Returns a PlotArea object that represents the plot area of a chart.
Public property 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.
Public property PlotVisibleOnly True if only visible cells are plotted. False if both visible and hidden cells are plotted.
Public property Previous Returns a Chart object that represents the previous sheet or cell.
Public property PrintedCommentPages Gets the number of comment pages that will be printed for the current chart.
Public property ProtectContents True if the contents of the sheet are protected. This protects the entire chart.
Public property ProtectData True if series formulas cannot be modified by the user.
Public property ProtectDrawingObjects True if shapes are protected.
Public property ProtectFormatting True if chart formatting cannot be modified by the user.
Public property ProtectGoalSeek True if the user cannot modify chart data points with mouse actions.
Public property 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.
Public property ProtectSelection True if chart elements cannot be selected.
Public property 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.
Public property 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.
Public property Scripts Returns the Scripts collection, which contains Script objects representing blocks of script or code in the specified document when it’s saved as a Web page.
Public property Shapes Returns a Shapes object that represents all the shapes on the worksheet or chart sheet. Read-only.
Public property ShowAllFieldButtons Gets or sets whether to display all field buttons on a PivotChart.
Public property ShowAxisFieldButtons Gets or sets whether to display axis field buttons on a PivotChart.
Public property ShowDataLabelsOverMaximum Returns or sets whether to show the data labels when the value is greater than the maximum value on the value axis. Read/write.
Public property ShowDraftModeButton Reserved for internal use.
Public property ShowLegendFieldButtons Gets or sets whether to display legend field buttons on a PivotChart.
Public property ShowReportFilterFieldButtons Gets or sets whether to display the report filter field buttons on a PivotChart.
Public property ShowValueFieldButtons Gets or sets whether to display the value field buttons on a PivotChart.
Public property 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.
Public property SideWall Returns a Walls object that allows the user to individually format the side wall of a 3-D chart. Read-only.
Public property 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).
Public property SubType Reserved for internal use.
Public property SurfaceGroup Returns a ChartGroup object that represents the surface chart group of a 3-D chart.
Public property Tab Returns a Tab object for a chart or a worksheet.
Public property Type Reserved for internal use.
Public property Visible Determines whether the object is visible.
Public property Walls Returns a Walls object that represents the walls of the 3-D chart.
Public property WallsAndGridlines2D True if gridlines are drawn two-dimensionally on a 3-D chart.
Top

  Name Description
Public method _ApplyDataLabels Reserved for internal use.
Public method _Dummy23 Reserved for internal use.
Public method _Evaluate Reserved for internal use.
Public method _PrintOut Reserved for internal use.
Public method _Protect Reserved for internal use.
Public method _SaveAs Reserved for internal use.
Public method Activate Makes the current chart the active chart.
Public method ApplyChartTemplate Applies a standard or custom chart type to a chart.
Public method ApplyCustomType Applies a standard or custom chart type to a chart.
Public method ApplyDataLabels Applies data labels to a point, a series, or all the series in a chart.
Public method ApplyLayout Applies the layouts shown in the ribbon.
Public method Arcs Reserved for internal use.
Public method 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).
Public method AutoFormat Reserved for internal use.
Public method Axes Returns an object that represents either a single axis or a collection of the axes on the chart.
Public method 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).
Public method Buttons Reserved for internal use.
Public method 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.
Public method 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.
Public method 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.
Public method CheckBoxes Reserved for internal use.
Public method CheckSpelling Checks the spelling of an object and displays the Spelling dialog box
Public method ClearToMatchStyle Clears the chart elements formatting to automatic.
Public method 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).
Public method Copy Copies the sheet to another location in the workbook.
Public method CopyChartBuild Reserved for internal use.
Public method CopyPicture Copies the selected object to the Clipboard as a picture.
Public method CreatePublisher Reserved for internal use.This member is for Macintosh only and should not be used.
Public method Delete Deletes the object.
Public method Deselect Cancels the selection for the specified chart.
Public method 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).
Public method DrawingObjects Reserved for internal use.
Public method Drawings Reserved for internal use.
Public method DropDowns For callouts with an explicitly set drop value, this property returns the vertical distance (in points) from the edge of the text bounding box to the place where the callout line attaches to the text box. Read-only Single.
Public method Evaluate Converts a Microsoft Excel name to an object or a value.
Public method Export Exports the chart in a graphic format.
Public method ExportAsFixedFormat Exports to a file of the specified format.
Public method 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.
Public method GroupBoxes Reserved for internal use.
Public method GroupObjects Reserved for internal use.
Public method Labels Reserved for internal use.
Public method 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).
Public method Lines Reserved for internal use. f
Public method ListBoxes Returns or sets the text entries in the specified list box or a combo box, as an array of strings, or returns or sets a single text entry. An error occurs if there are no entries in the list.
Public method Location Moves the chart to a new location.
Public method Move Moves the sheet to another location in the workbook.
Public method 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.
Public method OptionButtons Reserved for internal use.
Public method Ovals Reserved for internal use.
Public method Paste Pastes chart data from the Clipboard into the specified chart.
Public method Pictures Reserved for internal use.
Public method 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).
Public method PrintOut Prints the object.
Public method PrintOutEx Reserved for internal use.
Public method PrintPreview Shows a preview of the object as it would look when printed.
Public method Protect Protects a chart so that it cannot be modified.
Public method 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).
Public method Rectangles Reserved for internal use.
Public method Refresh Updates the cache of the Chart or PivotTable object.
Public method SaveAs Saves changes to the chart or worksheet in a different file.
Public method SaveChartTemplate Saves a custom chart template to the list of available chart templates.
Public method ScrollBars Reserved for internal use.
Public method Select Selects the object.
Public method 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.
Public method SetBackgroundPicture Sets the background graphic for a worksheet or chart.
Public method SetDefaultChart Specifies the name of the chart template that Microsoft Excel uses when creating new charts.
Public method SetElement Sets chart elements on a chart. Read/write.
Public method SetSourceData Sets the source data range for the chart.
Public method Spinners Reserved for internal use.
Public method TextBoxes Reserved for internal use.
Public method Unprotect Removes protection from a sheet or workbook. This method has no effect if the sheet or workbook isn't protected.
Public method 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
Show:
© 2015 Microsoft